/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 votes164 views1 answer
Two digits after decimal point in php
PHP
1 vote177 views1 answer
Select selected fields in laravel join
PHP
0 vote165 views1 answer
Undefined offset: 0 at laravel\framework\src\Illuminate\Routing\Router.php
PHP
0 vote313 views1 answer
How to use attempt in laravel
PHP Laravel
0 vote206 views1 answer
Laravel migration add contraint to other database
PHP Laravel
2 votes227 views1 answer
Sanctum auth check?
PHP
32 votes198 views6 answers
Php get ip address
PHP
0 vote163 views2 answers
Laravel collection reduce
PHP
2 votes175 views3 answers
Kill phpstorm
PHP
1 vote239 views1 answer
Php get total amount of days in month
PHP