/PHP/Laravel/User order by role spatie laravel

User order by role spatie laravel

$values = Team::query()
      ->leftJoin('users', 'users.team_id', '=', 'teams.id')
      ->leftJoin('model_has_roles', function ($join) {
          $join->on('model_has_roles.model_id', '=', 'users.id')
               ->where('model_has_roles.model_type', '=', 'appModelsUser');
      })
      ->leftJoin('roles', 'roles.id', '=', 'model_has_roles.role_id')
      ->orderBy('roles.name')
      ->get();

Source: coderedirect.com

Similar codes

0 vote283 views4 answers
Laravel collection contains
PHP Laravel
35 votes280 views6 answers
Laravel make auth
PHP Laravel
20 votes301 views3 answers
Make specific migration laravel
PHP Laravel
0 vote302 views1 answer
Media library laravel maximum allowed size
PHP Laravel
0 vote247 views1 answer
Laravel login shows 404
PHP Laravel
0 vote281 views1 answer
Laravel api error return homepage
PHP Laravel
0 vote308 views1 answer
Flexslider in laravel 5.8
PHP Laravel
24 votes292 views4 answers
Clear cache command in laravel controller
PHP Laravel
2 votes286 views2 answers
Get all data eloquent laravel
PHP Laravel
5 votes294 views2 answers
Laravel chmod
PHP Laravel