/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 vote309 views4 answers
Share var in a maser layout laravel
PHP Laravel
0 vote341 views2 answers
Laravel undefined index
PHP Laravel
9 votes339 views4 answers
Composer laravel ui
PHP Laravel
2 votes334 views1 answer
How get all files name in one folder in laravel
PHP Laravel
0 vote336 views1 answer
Raw query in laravel with parameters
PHP Laravel
-1 vote348 views4 answers
How to include file in laravel blade
PHP Laravel
0 vote289 views1 answer
Laravel download file from storage with progress bar
PHP Laravel
0 vote345 views1 answer
Laravel nova resolveUsing
PHP Laravel
0 vote352 views1 answer
Laravel where on relationsship column
PHP Laravel
5 votes321 views2 answers
Laravel print exception message
PHP Laravel