Defining a Has Many Through Eloquent Relationship

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

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\HasManyThrough;

class Country extends Model
{
    // A Country has many Posts through its Users
    public function posts(): HasManyThrough
    {
        return $this->hasManyThrough(Post::class, User::class);
    }

    // A Country has many Users directly (for context)
    public function users()
    {
        return $this->hasMany(User::class);
    }
}

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

use Illuminate\Database\Eloquent\Model;

class User extends Model
{
    public function country()
    {
        return $this->belongsTo(Country::class);
    }

    public function posts()
    {
        return $this->hasMany(Post::class);
    }
}

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

use Illuminate\Database\Eloquent\Model;

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

// Database structure (simplified):
// countries: id, name
// users: id, country_id, name
// posts: id, user_id, title

// Usage Example
$country = Country::find(1);

// Get all posts for this country via its users
$posts = $country->posts;

foreach ($posts as $post) {
    echo "Post Title: " . $post->title . "
";
}

// You can also add constraints
$activePosts = $country->posts()->where('posts.active', true)->get();