/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 vote194 views1 answer
Laravel createmany example
PHP Laravel
0 vote161 views1 answer
Laravel breeze rquire
PHP Laravel
3 votes171 views4 answers
Delete multiple row by model in laravel
PHP Laravel
0 vote201 views1 answer
Current time input field in laravel form
PHP Laravel
3 votes184 views2 answers
Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes) laravel
PHP Laravel
0 vote179 views2 answers
Laravel livewire-datatable delete column pop up issue
PHP Laravel
1 vote190 views2 answers
Get the value without setter method laravel
PHP Laravel
3 votes178 views1 answer
Run laravel cron job on cpanel
PHP Laravel
2 votes203 views1 answer
Laravel get list of columns in a table
PHP Laravel
1 vote264 views1 answer
Laravel profile migration tool
PHP Laravel