/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

9 votes162 views5 answers
Laravel exist
PHP Laravel
22 votes137 views5 answers
Update or insert in laravel
PHP
2 votes173 views1 answer
How to make a model in folder in laravel
PHP Laravel
1 vote137 views2 answers
Running laravel as host
PHP Laravel
32 votes137 views1 answer
How to count the characters in laravel
PHP Laravel
1 vote122 views2 answers
Add filter in wordpress
PHP
0 vote84 views1 answer
Php download temp file
PHP
0 vote146 views1 answer
Delete folder laravel
PHP Laravel
0 vote141 views1 answer
Laravel - Add conditional where clause in query
PHP Laravel
1 vote124 views1 answer
Image uploading and validation php
PHP