/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 vote256 views1 answer
Old value on edit table laravel 6
PHP Laravel
0 vote189 views1 answer
Laravel faker generate country code
PHP Laravel
0 vote302 views1 answer
Laravel - access file from storage path - alternative to symlink
PHP Laravel
0 vote229 views1 answer
Laravel get file to browser send
PHP Laravel
2 votes223 views1 answer
Laravel scout import command
PHP Laravel
4 votes183 views2 answers
Laravel form method delete
PHP Laravel
45 votes332 views6 answers
Laravel run seeder
PHP Laravel
0 vote202 views1 answer
Laravel post index method
PHP Laravel
0 vote186 views1 answer
Laravel role
PHP Laravel
49 votes288 views6 answers
Laravel when
PHP Laravel