/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 vote168 views1 answer
Laravel price database
PHP Laravel
0 vote166 views1 answer
Update function laravel 7
PHP
0 vote160 views1 answer
Encrypt/decrypt data php
PHP
0 vote283 views2 answers
Yii2 get params from url
PHP Yii
-1 vote169 views3 answers
Laravel except route
PHP
0 vote171 views1 answer
Composer remove phpmailer
PHP
0 vote188 views1 answer
Many to many relationship in laravel example stackoverflow
PHP Laravel
0 vote169 views1 answer
Add script tag to wordpress Head
PHP Wordpress
17 votes163 views6 answers
Php migrate
PHP
1 vote190 views2 answers
Symnfony bearer token
PHP