/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 vote348 views1 answer
Get records from Sunday to Sunday laravel
PHP Laravel
13 votes331 views6 answers
Prefix laravel route
PHP Laravel
1 vote358 views1 answer
Integer nullable laravel
PHP Laravel
0 vote395 views1 answer
Laravel valet refresh env
PHP Laravel
0 vote350 views1 answer
Disable laravel passport
PHP Laravel
1 vote347 views1 answer
Check if url is https laravel
PHP Laravel
8 votes363 views4 answers
Laravel unique validation on multiple columns
PHP Laravel
1 vote371 views2 answers
Where clause with paginate laravel multiple column
PHP Laravel
3 votes355 views1 answer
Laravel e commerce full project
PHP Laravel
1 vote363 views3 answers
Laravel multiple paginate
PHP Laravel