/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

2 votes184 views2 answers
Downgrade php 7.4 to 7.3 mac
PHP
0 vote252 views1 answer
Access storage from the view laravel 6
PHP
2 votes246 views1 answer
Create laravel project old version
PHP Laravel
1 vote175 views1 answer
Laravel plural
PHP
0 vote198 views1 answer
Limit query codeiniter 3
PHP
1 vote216 views1 answer
How to return with open model popup in laravel
PHP Laravel
6 votes221 views4 answers
Composer autoload
PHP
2 votes133 views1 answer
Check if div is empty javascript
PHP
0 vote216 views1 answer
Php return associative array
PHP
33 votes204 views6 answers
Migrate specific migration laravel
PHP