/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

12 votes154 views2 answers
Timestamp false in laravel
PHP Laravel
0 vote173 views2 answers
Laravel collection search
PHP Laravel
12 votes169 views2 answers
Laravel query with trashed
PHP Laravel
1 vote150 views2 answers
Laravel model set new attribute
PHP Laravel
0 vote172 views1 answer
Use s3 storage laravel
PHP Laravel
3 votes173 views5 answers
Laravel set env to production
PHP Laravel
7 votes159 views4 answers
Laravel route namespace and prefix
PHP Laravel
4 votes172 views3 answers
Laravel 8 check if null or empty
PHP Laravel
1 vote157 views1 answer
Cart laravel
PHP Laravel
0 vote191 views1 answer
Deleting all files inside a directory laravel 8
PHP Laravel