/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

1 vote216 views1 answer
Laravel plural and singular
PHP Laravel
8 votes225 views2 answers
Laravel storage hard link
PHP Laravel
5 votes223 views5 answers
Laravel where creation is today carbon
PHP Laravel
0 vote228 views1 answer
Laravel delete controller still cached
PHP Laravel
0 vote208 views1 answer
Laravel polymorphic relationship why we need this relation orm,
PHP Laravel
0 vote338 views3 answers
Laravel model sync
PHP Laravel
7 votes283 views1 answer
Laravel db seed specific class
PHP Laravel
0 vote278 views1 answer
Laravel get all vendor files
PHP Laravel
2 votes236 views2 answers
Bootstrap pagination laravel
PHP Laravel
1 vote363 views1 answer
Laravel fixed character limit
PHP Laravel