/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

4 votes328 views2 answers
Php check if variable is string
PHP
1 vote389 views3 answers
Laravel model to array
PHP Laravel
1 vote390 views2 answers
Laravel eloquent join two models
PHP Laravel
3 votes349 views1 answer
Check file size validation laravel
PHP Laravel
40 votes329 views4 answers
How to split string into array php
PHP
0 vote331 views1 answer
Php add get to link
PHP
0 vote371 views1 answer
Load differenet .env file in laravel
PHP Laravel
4 votes314 views2 answers
Pdo last id
PHP
0 vote392 views1 answer
Laravel/framework[v7.29.0, ..., 7.x-dev] require ext-mbstring * -> it is missing from your system. Install or enable PHP's mbstring extension.
PHP Laravel
0 vote375 views1 answer
Heroku deploy php
PHP