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

4 votes185 views2 answers
Laravel sum group by
PHP Laravel
0 vote123 views1 answer
Create newfilter wordpress
PHP
8 votes169 views4 answers
Php print to console
PHP
4 votes120 views1 answer
Uuid nom package for laravel 18.04
PHP
4 votes123 views1 answer
Wp enqueue
PHP
0 vote132 views1 answer
Meyfa/phpunit-assert-gd[v2.0.0, ..., v2.x-dev, v3.0.0] require ext-gd * -> it is missing from your system. Install or enable PHP's gd extension
PHP
0 vote151 views1 answer
Laravel checkbox checked
PHP Laravel
2 votes75 views1 answer
Php variable in alert box
PHP
1 vote199 views1 answer
Laravel fixed character limit
PHP Laravel
0 vote99 views1 answer
Laravel eloquent mass assignments
PHP Laravel