/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 vote119 views1 answer
Drupal 7 db_query example
PHP
8 votes154 views4 answers
Join multiple tables in laravel eloquent
PHP Laravel
0 vote151 views1 answer
Carbon previous day
PHP
0 vote154 views2 answers
Laravel General error: 1215 Cannot add foreign key constraint"
PHP Laravel
16 votes127 views3 answers
Php unique random number
PHP
0 vote156 views1 answer
How uplpoad video in laravel
PHP Laravel
0 vote151 views3 answers
Embed the site when you click on the link laravel
PHP
8 votes125 views6 answers
Php isset
PHP
48 votes155 views6 answers
Laravel make controller with model
PHP
0 vote152 views1 answer
Wordpress exclude current post from loop
PHP