Many to many showing only few rows

Have you tried it another way?

$node = Node::with('tags')->find(1723);

return $node;

In your view you can then do

@foreach ($node->tags as $tag)

@endforeach

This is the proper way of retrieving relationships and using them throughout your application!

Documentation: https://laravel.com/docs/5.6/eloquent-relationships#eager-loading

@bobbybouwmann I tried, same result, only two tags rows

$node = Node::select('id')->with('tags')->find(1723);
return $node;

Giving Result

{"id":1723,"tags":[{"id":58,"name":"civil","created_at":"2018-05-23 14:15:51","updated_at":"-0001-11-30 00:00:00","pivot":{"node_id":1723,"tag_id":58}},{"id":168,"name":"general","created_at":"2018-05-23 14:15:51","updated_at":"-0001-11-30 00:00:00","pivot":{"node_id":1723,"tag_id":168}}]}

What result does second implementation return?

return $user = DB::table('node_tag')->where('node_id', 1723)->get();

@arctushar

Maybe the model has Global scope, e.g. soft delete and in the "tags" table they are removed. there's no scope in the DB::table

if you have soft delete try something like this

        $node = Node::with('tags' => function($query){
                $query->withTrashed();
        })->find(1723);

return $node;

@Artak For your cod error is

syntax error, unexpected '=>' (T_DOUBLE_ARROW), expecting ',' or ')'

Your last code need [ ] for with , I changed it to with

    $node = Node::with(['tags' => function($query){
                $query->withTrashed();
        }])->find(1723);

In this case error is

Method Illuminate\Database\Query\Builder::withTrashed does not exist.

show your Node and Tag models

Node model

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Node extends Model
{
    public function users(){
        return $this->belongsToMany('App\User');
    }
    public function tags(){
        return $this->belongsToMany('App\Tag');
    }
    public function statistics(){
        return $this->belongsToMany('App\Statistic');
    }   
    public function nodedescription(){
        return $this->hasOne('App\Nodedescription');
    }   
}

Tag model

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Tag extends Model
{
    public function nodes(){
        return $this->belongsToMany('App\Node');
    }
}

Can you show the data in the database? Are you sure not two of them are deleted?

I've never seen a case where Laravel is not returning all results when you retrieve data!

You can try this way.

 public function tags(){
        return $this->belongsToMany('App\Tag');
    }

 public function nodes(){
        return $this->belongsToMany('App\Node');
    }

fetch data from pivot or intermediate table.

$node=Node::with('tags')->get();
return $node;

**It will show the Json Data. **

What's the result of dd(Node::find(1723)->tags()->toSql());?