/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

2 votes311 views1 answer
Php create an image
PHP
0 vote290 views3 answers
Count with left join in laravel
PHP
5 votes295 views2 answers
Php global variable function
PHP
37 votes295 views3 answers
Php unset array element
PHP
0 vote323 views1 answer
Php mess detector laravel
PHP
91 votes334 views6 answers
How to check if a string contains a substring in php
PHP
0 vote304 views1 answer
Php edit link
PHP
20 votes290 views5 answers
Carbon date from format
PHP
3 votes309 views2 answers
How to change laravel port
PHP
5 votes370 views2 answers
Laravel APP_ENV config
PHP Laravel