/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

0 vote139 views1 answer
Make controller laravel history open link
PHP
1 vote170 views2 answers
Get all values inside session laravel
PHP Laravel
8 votes146 views3 answers
Php key_exists
PHP
0 vote170 views1 answer
Creer un modele laravel
PHP
1 vote107 views5 answers
How to generate current date in php
PHP
12 votes148 views6 answers
Clear session php
PHP
4 votes144 views2 answers
Laravel order by random
PHP
0 vote172 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP Laravel
5 votes135 views1 answer
Check composer php version
PHP
0 vote197 views1 answer
Laravel model where set fields laravel
PHP