/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 vote222 views1 answer
Symfony header token authorization
PHP
0 vote231 views1 answer
Encapsulation in PHP
PHP
0 vote237 views1 answer
Odoctrine querybuilder print sql
PHP
18 votes223 views3 answers
Php try json decode
PHP
-1 vote227 views1 answer
Email php using html
PHP
0 vote285 views1 answer
Laravel form in 24 hours format
PHP Laravel
1 vote259 views1 answer
Check if delete query was successful laravel
PHP Laravel
18 votes261 views6 answers
Redirect to route laravel
PHP Laravel
0 vote187 views1 answer
Php join array to parenthesis
PHP
0 vote304 views1 answer
Laravel joins eloquent model
PHP