/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 vote231 views1 answer
Tinyinteger laravel +size
PHP Laravel
0 vote234 views1 answer
How to create module in laravel
PHP Laravel
1 vote206 views3 answers
Laravel convert timestamp to date
PHP Laravel
2 votes209 views2 answers
Check if date between two dates laravel eloquent
PHP Laravel
0 vote215 views1 answer
Test laravel scheduler
PHP Laravel
4 votes202 views2 answers
Display all errors at once in laravel
PHP Laravel
0 vote213 views1 answer
Not get child all data in relationship with parent laravel eloquent
PHP Laravel
0 vote207 views1 answer
Laravel eloquent set timestamps values upon seed
PHP Laravel
46 votes259 views6 answers
Laravel make controller with model
PHP Laravel
1 vote205 views1 answer
How to insert multiple data at a time with create method in laravel
PHP Laravel