/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 vote275 views1 answer
How to calculate age using query builder in laravel?
PHP Laravel
4 votes204 views3 answers
Laravel return json header json
PHP
0 vote186 views1 answer
WordPress Shortcode API
PHP
1 vote202 views1 answer
How to get array dont similer elements in php
PHP
0 vote204 views2 answers
How to remove copyright footer from xenforo 2
PHP
0 vote195 views1 answer
Check if given date time is of today or yesterday php
PHP
1 vote248 views1 answer
Boot method laravel
PHP
0 vote275 views1 answer
Laravel env pgsql
PHP Laravel
0 vote195 views5 answers
Download file laravel s3
PHP
0 vote224 views1 answer
Menyimpan get di laravel
PHP Laravel