/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

4 votes95 views1 answer
How to check query execution time in php
PHP
0 vote118 views1 answer
Image not save laravel
PHP Laravel
37 votes105 views6 answers
Carbon now format
PHP
0 vote108 views2 answers
Laravel eloquent select case when
PHP
1 vote104 views1 answer
Teruglopende for loop php
PHP
7 votes122 views1 answer
Laravel eloquent date range
PHP Laravel
6 votes111 views1 answer
__construct
PHP
2 votes104 views2 answers
Get users other than specific role laravel role spatie
PHP
0 vote96 views1 answer
Php insert char before each letter using regex
PHP
-1 vote141 views5 answers
Php version 7.4
PHP