/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

6 votes184 views2 answers
Laravel generate key
PHP Laravel
0 vote194 views1 answer
Laravel get biggest id
PHP Laravel
0 vote221 views1 answer
Laravel add model to one to many relationship
PHP Laravel
0 vote214 views1 answer
Logout all users laravel 8
PHP Laravel
0 vote208 views1 answer
Drop foreign key laravel eloquent
PHP Laravel
-1 vote217 views1 answer
Chrome web driver laravel
PHP Laravel
0 vote202 views1 answer
Laravelda cortollerga keladigan zaproslarni cheklash
PHP Laravel
-2 votes191 views1 answer
Laravel add user
PHP Laravel
0 vote223 views1 answer
Old value on edit table laravel 6
PHP Laravel
1 vote213 views1 answer
Laravel create project in current directory
PHP Laravel