/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 vote128 views1 answer
'laravel'
PHP Laravel
5 votes129 views6 answers
Sync laravel
PHP Laravel
1 vote121 views2 answers
Laravel collection isNotEmpty
PHP Laravel
1 vote169 views1 answer
Laravel search data relationship
PHP Laravel
0 vote120 views1 answer
Laravel display multiple selected values
PHP Laravel
0 vote134 views1 answer
Yajra laravel datatables rawcolumn
PHP Laravel
3 votes134 views3 answers
Pluck array in laravel
PHP Laravel
1 vote129 views3 answers
Print query statement in laravel
PHP Laravel
0 vote139 views1 answer
Optimistic Locking Laravel
PHP Laravel
0 vote129 views1 answer
Morph laravel without classes name
PHP Laravel