/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 vote117 views1 answer
Double in migration laravel
PHP Laravel
18 votes122 views1 answer
Schema::default string laravel
PHP Laravel
3 votes66 views1 answer
Eloquent first
PHP Laravel
26 votes111 views6 answers
Laravel model with migration
PHP Laravel
0 vote112 views1 answer
Why phpunit don't work in commend laravel
PHP Laravel
0 vote115 views3 answers
Laravel collection each
PHP Laravel
1 vote61 views1 answer
Laravel validation on fields inside array in request
PHP Laravel
0 vote119 views1 answer
Laravel datatable render html
PHP Laravel
46 votes161 views3 answers
How to check laravel version in cmd
PHP Laravel
0 vote137 views1 answer
How to update request all value in laravel controller before save in database
PHP Laravel