/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

8 votes359 views6 answers
Laravel collection unique
PHP Laravel
0 vote382 views1 answer
Laravel creating event get data
PHP Laravel
0 vote324 views2 answers
Laravel download file from public folder
PHP Laravel
1 vote330 views1 answer
How handle the number with k in laravel balde
PHP Laravel
2 votes334 views1 answer
Base64 encode laravel
PHP Laravel
9 votes328 views3 answers
Laravel validation image or file
PHP Laravel
0 vote292 views1 answer
Php laravel convert blob type to string
PHP Laravel
1 vote334 views2 answers
Install laravel in ubuntu 20.04
PHP Laravel
5 votes322 views2 answers
A non well formed numeric value encountered laravel
PHP Laravel
14 votes340 views5 answers
Laravel model tablename
PHP Laravel