/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

6 votes170 views4 answers
Unique check with multiple columns laravel validation
PHP Laravel
0 vote166 views1 answer
Laravel get request check
PHP Laravel
0 vote204 views1 answer
Cut pice of text in laravel
PHP Laravel
4 votes161 views5 answers
Laravel storage folder permissions
PHP Laravel
11 votes172 views5 answers
Laravel redirect back url with message
PHP Laravel
1 vote182 views2 answers
Add laravel sail build as alias
PHP Laravel
0 vote130 views1 answer
Appserviceprovider laravel share common settings for all controllers
PHP Laravel
0 vote214 views2 answers
Declare variable in view for loop laravel
PHP Laravel
13 votes190 views6 answers
How to create model in laravel
PHP Laravel
7 votes182 views3 answers
How to show validation error in laravel blade
PHP Laravel