/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 vote137 views1 answer
Laravel get first letter of each word
PHP Laravel
0 vote136 views1 answer
Laravel 8 template favicon
PHP Laravel
-1 vote88 views1 answer
Check request method laravel
PHP Laravel
4 votes136 views2 answers
How to create access token in laravel
PHP Laravel
1 vote140 views1 answer
Use app name in laravel blade
PHP Laravel
4 votes132 views4 answers
Laravel sum relationship column
PHP Laravel
9 votes131 views3 answers
Pass variable to blade laravel
PHP Laravel
-1 vote140 views2 answers
Laravel model save get id
PHP Laravel
49 votes198 views6 answers
Laravel clear all cache
PHP Laravel
0 vote146 views1 answer
Add custom attribute for validation errors laravel
PHP Laravel