Better way to get this query :) HELP

I'm not sure what you're asking.

You can add withPivot('chat_room') to the original query to have it included with the connections.

thanks @frankincredible I did this way

  public function connections()
  {
    return $this->belongsToMany('App\User' , 'user_user' , 'user_id' , 'connect_id' )->withPivot('show', 'chat_room')->withTimestamps();
}

okay I am asking if there is other way to call the pivot table... just if there exist the way if not I will leave it that way

Maybe you might try to use the with:: see this post: https://stackoverflow.com/questions/19852927/get-specific-columns-using-with-function-in-laravel-eloquent hope to help

Alternatively you can make a Model for the actual pivot itself, and write a relation that just returns the pivot. It's up to you.

From the official docs:

you may wish to rename your intermediate table accessor to subscription instead of pivot. This can be done using the as method when defining the relationship:

return $this->belongsToMany('App\Podcast')
                ->as('subscription')
                ->withTimestamps();

Once this is done, you may access the intermediate table data using the customized name:

$users = User::with('podcasts')->get();

foreach ($users->flatMap->podcasts as $podcast) {
    echo $podcast->subscription->created_at;
}

thanks I made this - thing is the best way to get the chat_room table

public function chatRooms()
{
    return $this->hasMany( 'App\ChatRooms' , 'user_id');
}

thanks for the advice @povilaskorop , I did not know the pivot could be rename :) excellent