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 votes179 views4 answers
Php artisan drop table
PHP
0 vote188 views1 answer
Codeigniter 4 query builder get inserted id
PHP CodeIgniter
0 vote110 views1 answer
Crontab php
PHP
0 vote141 views1 answer
Php change an associative array into indexed array
PHP
3 votes156 views1 answer
Php grab year from date
PHP
0 vote157 views2 answers
Laravel eloquent without relation
PHP
0 vote145 views1 answer
Leggere file su piu righe php
PHP
0 vote147 views1 answer
Php check method of http request
PHP
0 vote161 views2 answers
Laravel return 1 as true
PHP Laravel
4 votes141 views2 answers
Get session blade
PHP