/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 vote168 views1 answer
Boot add schema in laravel
PHP Laravel
0 vote168 views1 answer
Check if column has value in laravel eloquent
PHP Laravel
0 vote143 views1 answer
Laravel withValidator
PHP Laravel
3 votes184 views1 answer
Insert rows in migrations laravel
PHP Laravel
3 votes148 views1 answer
Laravel carbon get year number
PHP Laravel
0 vote150 views2 answers
View blade not found in laravel
PHP Laravel
13 votes168 views6 answers
Prefix laravel route
PHP Laravel
0 vote160 views1 answer
How to check if a user is logged in in a non middleware controller in laravel
PHP Laravel
1 vote237 views2 answers
Get ip in laravel
PHP Laravel
0 vote154 views2 answers
Laravel General error: 1215 Cannot add foreign key constraint"
PHP Laravel