/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

0 vote337 views1 answer
Setup laravel on AWS
PHP Laravel
0 vote402 views1 answer
Laravel sql illegal collation
PHP Laravel
11 votes352 views3 answers
Laravel auth 6
PHP Laravel
7 votes359 views1 answer
Laravel auth user_id
PHP Laravel
3 votes400 views2 answers
Laravel image max size validation
PHP Laravel
0 vote405 views1 answer
Formate date using carbon in laravel blade
PHP Laravel
0 vote383 views2 answers
Curl post laravel
PHP Laravel
8 votes326 views3 answers
Storage link laravel
PHP Laravel
7 votes366 views2 answers
How to start composer in laravel project on localhost
PHP Laravel
0 vote394 views1 answer
Custom pagination laravel css
PHP Laravel