Get User Roles

Hi @gravitano,

currently I use the following syntax to find all roles to a user:

 DB::table('users')->join('role_user', 'users.id', '=', 'role_user.user_id')->join('roles', 'roles.id', '=', 'role_user.role_id')->select('users.id', 'users.username', 'users.name', 'roles.name as role');

Is there an easier solution ?

Greetings!

[gravitano]

You can try use eloquent.

$user = User::find(1);

$user->roles;