/PHP/Laravel/Avg rating get in join in laravel 8

Avg rating get in join in laravel 8

$users = User::where('type', 'instructor')->get();
  foreach ($users as $user) {
      $user['ratings'] = $user->ratings()->avg('rate');
  }
  return $users;


$data = User::with('ratings')
->join('Rating table','user.id','=','Rating table.user_id')
->select('user.*',DB::raw('avg(rating_for_user)'))
->get();

Similar codes

0 vote345 views1 answer
Install Older Version of Laravel using Composer
PHP Laravel
0 vote351 views1 answer
Laravel carbon Could not parse '28/09/2021, 12:00:00 pm': DateTime::__construct(): Failed to parse time string (28/09/2021, 12:00:00 pm) at position 0 (2): Unexpected character
PHP Laravel
5 votes349 views4 answers
Create database from migration laravel for all
PHP Laravel
0 vote398 views1 answer
Laravel request protected prop
PHP Laravel
0 vote353 views2 answers
Send html from datatable in laravel
PHP Laravel
0 vote336 views3 answers
Laravel query order by relation
PHP Laravel
0 vote358 views1 answer
How to execute “php artisan migrate” and other Laravel commands in remote server?
PHP Laravel
0 vote352 views1 answer
Create symbolic in lumen laravel
PHP Laravel
6 votes345 views5 answers
Migration rename column laravel
PHP Laravel
-1 vote334 views3 answers
@parent, @include, @show blade in laravel
PHP Laravel