/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

1 vote332 views1 answer
Laravel $loop interation
PHP Laravel
0 vote324 views1 answer
Javascript inside php
PHP
2 votes327 views2 answers
Php array_fill
PHP
0 vote316 views1 answer
Union type php does not work
PHP
10 votes377 views4 answers
Error_log wordpress
PHP Wordpress
0 vote321 views1 answer
Php shell_exec with root
PHP
0 vote345 views3 answers
Add factory data laravel
PHP Laravel
0 vote366 views1 answer
Laravel mysql specified key was too long
PHP Laravel
5 votes311 views4 answers
Laravel auth register false
PHP Laravel
0 vote309 views1 answer
Laravel factory counter
PHP Laravel