/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 vote212 views1 answer
Guzzlehttp/guzzle version with laravel-websockek
PHP Laravel
0 vote162 views1 answer
Laravel storage goes to 404 page. (Symlink not working)
PHP Laravel
0 vote177 views1 answer
Laravel Add regx on password
PHP Laravel
1 vote189 views1 answer
Laravel validation types for float
PHP Laravel
0 vote233 views2 answers
Reload page laravel
PHP Laravel
6 votes170 views4 answers
Illuminate database queryexception could not find driver laravel
PHP Laravel
0 vote173 views1 answer
Laravel migration add contraint to other database
PHP Laravel
0 vote159 views1 answer
Can we use 2 select in a query laravel
PHP Laravel
8 votes191 views3 answers
Laravel redirect back with errors and input
PHP Laravel
0 vote151 views1 answer
Order by in datatable laravel
PHP Laravel