/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 vote192 views2 answers
Laravel date format valdiate
PHP Laravel
2 votes171 views1 answer
Laravel get only the Ids of an eloquent arrays
PHP Laravel
23 votes158 views4 answers
Laravel carbon isoformat
PHP Laravel
10 votes218 views4 answers
Laravel migration change column default
PHP Laravel
0 vote168 views2 answers
How to implement maatwebsite excel in my laravel project
PHP Laravel
0 vote161 views1 answer
Laravel check if postback
PHP Laravel
1 vote180 views1 answer
Laravel best practices
PHP Laravel
0 vote171 views1 answer
How to add page link in laravel
PHP Laravel
1 vote178 views1 answer
Types of looping directives in laravel
PHP Laravel
3 votes154 views2 answers
Laravel tinker generate password
PHP Laravel