/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

29 votes175 views5 answers
Php server
PHP
1 vote192 views1 answer
Laravel singular
PHP
1 vote241 views1 answer
Laravel blade skip entry
PHP Laravel
0 vote180 views1 answer
Tax query by term id
PHP
0 vote193 views1 answer
Request update password laravel
PHP Laravel
6 votes198 views4 answers
Laravel force delete
PHP Laravel
2 votes163 views2 answers
Wp is user admin
PHP
0 vote213 views2 answers
Php mb_convert_encoding utf8 extended
PHP
13 votes405 views5 answers
Laravel add item to array
PHP Laravel
0 vote162 views1 answer
Php usort method of class
PHP