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

1 vote334 views2 answers
Install laravel in ubuntu 20.04
PHP Laravel
0 vote272 views1 answer
Order by array like sql php
PHP
0 vote286 views1 answer
Show woocommerce products in the form of table
PHP
0 vote278 views1 answer
Nl2br is not working for database in php
PHP
-1 vote279 views1 answer
Php ajouter += ou =+
PHP
2 votes271 views1 answer
Laravel vendor:publish not working
PHP
1 vote300 views1 answer
How to retrieve value from stdclass array in php
PHP
0 vote301 views1 answer
If post checked category wordpress
PHP
25 votes315 views6 answers
Calculate the Difference Between Two Dates Using PHP
PHP
0 vote270 views1 answer
Laravel migrate patth
PHP Laravel