/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 vote226 views1 answer
Password validation rules laravel
PHP Laravel
0 vote257 views2 answers
Laravel PackageManifest.php: Undefined index: name
PHP Laravel
3 votes225 views3 answers
Laravel collection combine
PHP Laravel
1 vote198 views2 answers
Laravel init
PHP Laravel
0 vote237 views1 answer
Create symbolic in lumen laravel
PHP Laravel
0 vote223 views1 answer
How to pluck fullname database laravel
PHP Laravel
18 votes225 views6 answers
Laravel form validation
PHP Laravel
12 votes219 views2 answers
Laravel update from query
PHP Laravel
1 vote180 views1 answer
Laravel check if eloquent just created
PHP Laravel
5 votes231 views3 answers
Laravel drop column if exists
PHP Laravel