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 vote218 views1 answer
Php filter non utf-8 characters
PHP
0 vote210 views1 answer
Php formula return more results
PHP
-1 vote216 views1 answer
Php artisan migrate error
PHP
0 vote251 views1 answer
Laravel 8 date difference in days
PHP Laravel
0 vote260 views2 answers
Dynamic Carousel in Laravel not working displays only one image
PHP Laravel
5 votes196 views3 answers
Laravel drop column if exists
PHP
0 vote212 views1 answer
Drupal 8 / 9 entityTypeManager get multiple comments by cid
PHP
5 votes222 views2 answers
Autoloader php
PHP
0 vote205 views1 answer
Get 1 data from get laravel
PHP
8 votes172 views2 answers
Laravel password hash online
PHP Laravel