/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

0 vote358 views1 answer
Laravel redis sentinel
PHP Laravel
0 vote364 views1 answer
Laravel php 8 ububtu
PHP Laravel
0 vote374 views1 answer
Generate slug on create laravel
PHP Laravel
0 vote380 views1 answer
Blade check user role laravel
PHP Laravel
0 vote391 views1 answer
Laravel delete controller still cached
PHP Laravel
2 votes363 views1 answer
Global laravel request()
PHP Laravel
0 vote429 views1 answer
How to get the root domain in laravel
PHP Laravel
16 votes365 views6 answers
Laravel redirect back
PHP Laravel
0 vote380 views1 answer
Laravel passport generate key
PHP Laravel
-2 votes403 views1 answer
Laravel if else condition in query
PHP Laravel