/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 vote238 views5 answers
Laravel tricks and tips
PHP Laravel
0 vote220 views1 answer
Laravel controller create command in a folder
PHP Laravel
0 vote248 views1 answer
Laravel change error page to open in vscode
PHP Laravel
0 vote237 views1 answer
Laravel Eloquent, group by month/year
PHP Laravel
0 vote268 views1 answer
Laravel download file change name
PHP Laravel
0 vote232 views1 answer
Display data from two dimensional array in vew laravel
PHP Laravel
0 vote237 views1 answer
Laravel 8 db like query
PHP Laravel
7 votes236 views2 answers
How to start composer in laravel project on localhost
PHP Laravel
2 votes246 views1 answer
Laravel scout import command
PHP Laravel
3 votes244 views3 answers
Laravel notification
PHP Laravel