/PHP/Laravel/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

6 votes217 views3 answers
How assign default value to laravel migration column
PHP Laravel
5 votes227 views5 answers
Table drop foreign php laravel
PHP Laravel
62 votes536 views6 answers
Clear cache laravel
PHP Laravel
1 vote200 views1 answer
Paystack gateway integration laravel
PHP Laravel
1 vote228 views1 answer
How match array in laravel collection
PHP Laravel
1 vote208 views2 answers
Set nav link active on the basis of route laravel 8
PHP Laravel
12 votes219 views6 answers
Set session data in laravel
PHP Laravel
0 vote217 views1 answer
Laravel get mysql column datatype
PHP Laravel
3 votes283 views2 answers
Associate laravel
PHP Laravel
1 vote209 views2 answers
How to delete a file in laravel
PHP Laravel