/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

8 votes238 views6 answers
Codeigniter 4 get last query
PHP
1 vote249 views2 answers
Unzip file php
PHP
2 votes259 views1 answer
Undefined type 'App\Http\Controllers\api\DB'.
PHP
15 votes217 views3 answers
Laravel timezone
PHP
0 vote224 views1 answer
Pdo bindparam string
PHP
0 vote231 views3 answers
Prevent re submit form on refresh javascript
PHP
2 votes242 views2 answers
Empty table in laravel
PHP Laravel
18 votes226 views6 answers
Php unix timestamp to date
PHP
0 vote231 views2 answers
Image upload in cake 2
PHP
1 vote216 views1 answer
Run jobs laravel
PHP