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 votes169 views5 answers
Php last day of month
PHP
0 vote155 views1 answer
Which programming languae does php resemble to?
PHP
9 votes185 views2 answers
Laravel query count raw
PHP Laravel
2 votes168 views2 answers
Wordpress show notice
PHP Wordpress
0 vote175 views1 answer
Get name of join by id php
PHP
3 votes206 views6 answers
Laravel find query
PHP Laravel
42 votes189 views6 answers
Laravel 8 foreign key
PHP Laravel
0 vote193 views1 answer
Laravel migration folder
PHP Laravel
0 vote143 views1 answer
How to get event dates on change in datetimepicker with laravel livewire
PHP Laravel
2 votes142 views2 answers
In PackageManifest.php line 131: Undefined index: name laravel 7
PHP