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 vote355 views1 answer
Wordpress plugin functions exist
PHP Wordpress
17 votes436 views3 answers
Debug wordpress
PHP Wordpress
0 vote324 views1 answer
How to solve php mysqli_query function problem does not execute
PHP
0 vote285 views1 answer
How to hide tax details from woocommerce order emails
PHP
0 vote326 views1 answer
Hook into admin add order item / product on add/submit
PHP
3 votes311 views1 answer
How to get video duration in php
PHP
0 vote300 views1 answer
Multi-idiomas com PHP
PHP
14 votes342 views5 answers
Php artisan migrate reset
PHP
0 vote285 views1 answer
Mysqldump is not recognized as an internal or external command laravel
PHP
2 votes375 views2 answers
Laravel validation unique email except self
PHP