/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

33 votes209 views2 answers
Add column migration laravel 8
PHP
8 votes196 views6 answers
PHP Date add days
PHP
0 vote137 views1 answer
Session() in lumen
PHP
7 votes209 views2 answers
Wordpress loop
PHP Wordpress
1 vote221 views3 answers
Php DateTime comparation
PHP
0 vote190 views1 answer
Get shipping price of choosen shipping method woocommerce
PHP
2 votes255 views1 answer
Debug query in moodle
PHP
1 vote306 views1 answer
Enable cors cakephp
PHP CakePHP
1 vote190 views1 answer
Laravel format number blade
PHP
7 votes165 views2 answers
Php laravel between dates
PHP