/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

47 votes350 views6 answers
Laravel create seeder
PHP Laravel
3 votes257 views1 answer
Send multiple mail in laravel
PHP Laravel
0 vote184 views1 answer
Laravel connection timed out
PHP Laravel
3 votes187 views2 answers
Default port for laravel
PHP Laravel
0 vote195 views1 answer
Seguridad de las api en laravel
PHP Laravel
0 vote200 views3 answers
Laravel migration softdelete
PHP Laravel
14 votes219 views6 answers
How to install laravel
PHP Laravel
0 vote208 views1 answer
Laravel migration add contraint to other database
PHP Laravel
0 vote205 views2 answers
Laravel get url without domain in blade
PHP Laravel
0 vote202 views1 answer
Laravel relationship retrieve data
PHP Laravel