/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

3 votes269 views2 answers
Laravel 8 Target class [FormController] does not exist.
PHP Laravel
2 votes211 views1 answer
Laravel checkbox terms and conditions
PHP Laravel
7 votes243 views3 answers
Laravel active menu item
PHP Laravel
9 votes272 views3 answers
Pass variable to blade laravel
PHP Laravel
0 vote247 views1 answer
How to find the name of login user in laravel
PHP Laravel
11 votes255 views3 answers
How to remove composer package in laravel
PHP Laravel
26 votes226 views6 answers
Laravel validation integer
PHP Laravel
0 vote255 views1 answer
Laravel get all old input
PHP Laravel
0 vote248 views2 answers
Share to facebook from website laravel
PHP Laravel
17 votes250 views6 answers
Update query laravel
PHP Laravel