/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

4 votes277 views2 answers
Php echo an array to console
PHP
0 vote333 views1 answer
How to check if query is successfully inserted laravel
PHP Laravel
0 vote293 views1 answer
Php inline variables string
PHP
0 vote277 views1 answer
Laravel bd query
PHP
0 vote293 views1 answer
Laravel collection except
PHP
0 vote274 views1 answer
PHP (WordPress) - Increase Maximum Upload File Size
PHP
6 votes348 views2 answers
Findorfail laravel
PHP Laravel
1 vote278 views2 answers
Laravel collection isNotEmpty
PHP Laravel
0 vote302 views1 answer
In ImageRetriever.php line 305 at ImageRetriever->getNoPictureImage(object(Language)) in FrontController.php line 1527
PHP
10 votes303 views2 answers
Laravel collection toArray
PHP