/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 votes236 views1 answer
Insall laravel
PHP Laravel
3 votes299 views1 answer
Laravel middleware route
PHP Laravel
11 votes234 views4 answers
Session variable in laravel
PHP Laravel
0 vote238 views1 answer
Parameters inside Laravel localized string
PHP Laravel
0 vote220 views1 answer
Action after model is created laravel
PHP Laravel
12 votes237 views4 answers
Count in laravel'
PHP Laravel
1 vote236 views1 answer
Integer nullable laravel
PHP Laravel
0 vote298 views3 answers
Laravel sync with attributes
PHP Laravel
0 vote229 views1 answer
Extension gd missing laravel composer update
PHP Laravel
0 vote223 views1 answer
Laravel vendor publish all files
PHP Laravel