/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 vote146 views1 answer
Copy env example to .env in laravel
PHP Laravel
1 vote138 views1 answer
Invalid datetime format laravel
PHP Laravel
0 vote155 views1 answer
Laravel 5.7
PHP Laravel
49 votes203 views6 answers
Laravel clear all cache
PHP Laravel
0 vote142 views2 answers
How to disable laravel cors
PHP Laravel
1 vote138 views2 answers
Laravel request all except
PHP Laravel
1 vote143 views1 answer
Bootstrap doesn't work in laravel
PHP Laravel
1 vote169 views1 answer
Get year in laravel 8
PHP Laravel
0 vote149 views1 answer
Create table laravel give name table
PHP Laravel
7 votes146 views3 answers
Laravel random query
PHP Laravel