/PHP/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 vote382 views1 answer
Laravel log query for model (full)
PHP Laravel
0 vote314 views1 answer
Sort an array in php manually
PHP
1 vote306 views1 answer
Carbor sub day
PHP
0 vote365 views1 answer
Time zone set in codeigniter
PHP CodeIgniter
59 votes346 views6 answers
Laravel seeder
PHP
0 vote340 views1 answer
Jquery serialize php decode
PHP
2 votes374 views2 answers
404 page in laravel
PHP Laravel
0 vote349 views1 answer
Method Illuminate\Support\Collection::appends does not exist.
PHP
1 vote325 views3 answers
Php ?:
PHP
0 vote340 views1 answer
Laravel faker value or null
PHP