/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 vote260 views1 answer
Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
PHP Laravel
5 votes233 views2 answers
Laravel migration change column length
PHP Laravel
0 vote251 views1 answer
Laravel - Add conditional where clause in query
PHP Laravel
0 vote272 views1 answer
Datetime-local laravel migration data type
PHP Laravel
1 vote276 views1 answer
Foreign key nullable in laravel
PHP Laravel
2 votes271 views3 answers
Laravel file exists
PHP Laravel
0 vote256 views1 answer
Running a laravel app locally
PHP Laravel
-2 votes275 views3 answers
Laravel when condition
PHP Laravel
51 votes337 views6 answers
Left join laravel
PHP Laravel
2 votes279 views1 answer
Laravel artisan create criteria
PHP Laravel