/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 vote245 views5 answers
Laravel Scheduler
PHP
7 votes274 views3 answers
Laravel how to call function in same controller
PHP Laravel
0 vote237 views1 answer
Convert image to base64 in laravel
PHP Laravel
0 vote265 views1 answer
Double where condition in laravel
PHP Laravel
0 vote233 views1 answer
Create fake users on click laravel
PHP Laravel
-2 votes221 views3 answers
Upgrade php 7.3 centos 7
PHP
8 votes206 views6 answers
Laravel collection unique
PHP
1 vote232 views1 answer
Orderby text values eliquent laravel
PHP Laravel
1 vote208 views1 answer
Why storage link do not work in host for laravel
PHP
0 vote233 views1 answer
Query relationships laravel and select some columns
PHP