/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 vote217 views1 answer
How to use old for select in blade laravel
PHP Laravel
1 vote195 views5 answers
Laravel eloquent batch insert
PHP Laravel
1 vote192 views1 answer
How convert the date and time to integer in laravel
PHP Laravel
0 vote184 views1 answer
Query without chaining not working - Laravel
PHP Laravel
0 vote219 views2 answers
Laravel PackageManifest.php: Undefined index: name
PHP Laravel
9 votes177 views1 answer
Npm run dev error laravel 8
PHP Laravel
0 vote193 views2 answers
Laravel blade components
PHP Laravel
0 vote199 views3 answers
Laravel migration softdelete
PHP Laravel
0 vote218 views1 answer
How to disable auto prediction html input in laravel
PHP Laravel
0 vote198 views1 answer
Set custome table laravel eloquent
PHP Laravel