/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 vote211 views1 answer
How to check if php is compiling
PHP
0 vote186 views1 answer
Php const scope
PHP
0 vote207 views1 answer
Artisa create event
PHP
0 vote254 views1 answer
$tmp = explode('.', $file_name); $file_extension = end($tmp); in array
PHP
4 votes180 views3 answers
Class "Controller" not found
PHP
0 vote180 views1 answer
How to create compomemt in laravel livewire
PHP
3 votes202 views4 answers
PHP executable not found. Install PHP 7 and add it to your PATH or set the php.executablePath setting
PHP
0 vote263 views1 answer
Php pass 2 date value to javascript
PHP
0 vote191 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP
0 vote183 views1 answer
Omnipay refund
PHP