/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

2 votes129 views2 answers
How to do laravel in sidebar active menu dynamic blade
PHP Laravel
4 votes118 views3 answers
Ubuntu where are laravel logs stored
PHP Laravel
0 vote119 views1 answer
Laravel check if postback
PHP Laravel
4 votes110 views2 answers
Laravel collection count
PHP Laravel
3 votes123 views2 answers
Laravel withtrashed
PHP Laravel
0 vote74 views1 answer
Laravel auth trying to get property 'instid' of non-object
PHP Laravel
2 votes137 views1 answer
Command to delete storage logs in laravel
PHP Laravel
22 votes110 views2 answers
Where status is null sql in laravel
PHP Laravel
3 votes125 views1 answer
Laravel send post request from controller
PHP Laravel
3 votes115 views2 answers
Laravel required if it meet some value from another field
PHP Laravel