Error using many to many laravel

You want to load users and also people's information, if it is, use:

Usuarios::where('usuario_id', $usuario_id)->with('Pessoas')->toSql();

For you to use the Pessoas function you need to call it from an instance of Usuarios , if you first call the where function you will not be able to call the Pessoas function because where returns an instance of the% Builder .

References:

• Eager Loadind (with)

To define the relationship Many To Many it is necessary to have 3 tables, in your case it would be: users , people and user_user . The 3 table should follow the pattern of alphabetical order.

In Model of Users you should put the following:

public function pessoas() {
    return $this->belongsToMany( Pessoas::class, 'pessoa_usuario' ); // Primeiro parâmetro é o Model que você vai se relacionar e o segundo é o nome da tabela.
}

The belongsToMany function gets 4 parameters we're using only 2 because I'm assuming its structure follows the pattern driven by Laravel. For more information just check documentation

And to list all users who have the relationship you just need to use the following:

Usuarios::where('usuario_id', $usuario_id)->with('Pessoas')->get();