/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 vote181 views1 answer
How to wirte laravel dd function in php
PHP Laravel
2 votes181 views2 answers
How to use stored procedure in laravel
PHP Laravel
1 vote167 views1 answer
Why laravel site loading only
PHP Laravel
0 vote171 views1 answer
Laravel adding new items to config run time
PHP Laravel
0 vote190 views1 answer
Laravel orm latest()
PHP Laravel
4 votes159 views2 answers
Check request header laravel
PHP Laravel
3 votes175 views2 answers
Different days in carbon laravel between different dates
PHP Laravel
0 vote169 views1 answer
Make() laravel
PHP Laravel
1 vote171 views2 answers
How to get data from a table in laravel
PHP Laravel
0 vote164 views1 answer
How to extract code from controller to helpers or other method in laravel
PHP Laravel