/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

30 votes282 views6 answers
Laravel auth
PHP Laravel
1 vote266 views1 answer
Isset blade laravel
PHP Laravel
23 votes279 views6 answers
Laravel validation messages
PHP Laravel
1 vote351 views1 answer
How to calculate age in laravel
PHP Laravel
18 votes289 views6 answers
Redirect to route laravel
PHP Laravel
0 vote309 views1 answer
Comparison of two tables in laravel using model
PHP Laravel
0 vote323 views1 answer
Create new controller laravel with model binding
PHP Laravel
1 vote282 views1 answer
Insert data using model in laravel 8
PHP Laravel
4 votes307 views4 answers
Laravel meta csrf
PHP Laravel
0 vote266 views1 answer
Laravel eloquent return array where
PHP Laravel