🚀 Laravel Tip: Optimize Queries with withAggregate 📊

WithAggregate.php

<?php 

// In the Post model
class Post extends Model
{
      public function user()
      {
             return $this->belongsTo(User::class);
      }
}

// To Load posts with user data using with Sposts
Post::with('user:id, name')→take (3)→get();

// SQL queries:
// select * from posts limit 3; // select id, 'name' from users where users. id in (1, 2, 3);
// Access user's name using user name!
$name = $posts first()→user name;

// To load posts with user's name aggregated using withAggregate'
$posts = Post::withAggregate('user', 'name')→take (3)→get();

// SQL query:
// select 'posts,*, (select name from 'users' where 'posts","user_id` = // as "user_name from 'posts' Limit 3;
// Access user's name using →user_name'
$name = $posts first()→user_name;