Laravel Eloquent ORM relation with pivot table

Table sample

user
    id - integer
    name - string

user-role
    user_id - integer
    role_id - integer

role
    id - integer
    title - string

 

class User extends Model
{
    /**
     * The roles that belong to the user.
     */
    public function roles()
    {       return $this->belongsToMany('App\Role', 'role_user', 'user_id', 'role_id');
        // 'role_user' - pivot table name
        // 'user_id' - foreign key on role_user table
        // 'role_id' - foreign key on  role_user table
} }

 

 

Leave a Reply

Your email address will not be published.