Optimizing Relationship Aggregates with Eloquent `withCount` and `withSum`

<?php

// app/Models/Post.php
namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    public function comments()
    {
        return $this->hasMany(Comment::class);
    }
    public function likes()
    {
        return $this->hasMany(Like::class);
    }
}

// app/Models/Comment.php (Assuming comments have a 'score' column)
namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Comment extends Model
{
    protected $fillable = ['body', 'score'];

    public function post()
    {
        return $this->belongsTo(Post::class);
    }
}

// Usage Example
// Retrieve posts and their comments count
$postsWithCounts = Post::withCount('comments')->get();

foreach ($postsWithCounts as $post) {
    echo "Post: {$post->title}, Comments Count: {$post->comments_count}
";
}

// Retrieve posts, comments count, and total score of comments
$postsWithCountsAndSums = Post::withCount('comments')
                            ->withSum('comments', 'score') // Sum the 'score' column of related comments
                            ->get();

foreach ($postsWithCountsAndSums as $post) {
    echo "Post: {$post->title}, Comments: {$post->comments_count}, Total Comment Score: {$post->comments_sum_score}
";
}

// You can also add conditional constraints
$postsWithSpecificCounts = Post::withCount(['comments' => function ($query) {
    $query->where('is_approved', true);
}])->get();

foreach ($postsWithSpecificCounts as $post) {
    echo "Post: {$post->title}, Approved Comments: {$post->comments_count}
";
}