/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

26 votes147 views6 answers
Laravel validation integer
PHP Laravel
0 vote178 views1 answer
Old value on edit table laravel 6
PHP Laravel
10 votes159 views2 answers
Laravel route list
PHP Laravel
7 votes147 views3 answers
Laravel 8 – Remove Public from URL
PHP Laravel
0 vote155 views1 answer
Laravel post index method
PHP Laravel
2 votes160 views2 answers
Laravel get file in public folder
PHP Laravel
0 vote147 views1 answer
Image not save laravel
PHP Laravel
0 vote128 views1 answer
How to get a list of registered route paths in Laravel?
PHP Laravel
1 vote146 views1 answer
Set subject for mail inlaravel
PHP Laravel
0 vote145 views1 answer
Validate user password laravel8
PHP Laravel