/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 vote273 views2 answers
How to retrieve image from database in php mysqli
PHP
5 votes381 views3 answers
Get result count codeigniter
PHP CodeIgniter
2 votes291 views1 answer
Laravel Call to a member function diffForHumans() on string
PHP Laravel
1 vote262 views2 answers
Install laravel in ubuntu 20.04
PHP
1 vote289 views1 answer
Sendinblue send mail
PHP
-1 vote285 views1 answer
Prestashop get product id
PHP
0 vote256 views1 answer
Get slogan wp
PHP
6 votes284 views5 answers
Check if a String Starts With a Specified String in PHP
PHP
0 vote280 views1 answer
Ternaire echo isset php
PHP
12 votes261 views6 answers
Php object
PHP