重构whereHas以通过Laravel中的全局作用域使用

use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Scope;

class User extends Model
{
    // ...

    public static function boot()
    {
        parent::boot();

        static::addGlobalScope(new ActiveUserScope);
    }
}

class ActiveUserScope implements Scope
{
    public function apply(Builder $builder, Model $model)
    {
        $builder->where('is_active', 1);
    }
}

use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    // ...

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

    public function scopeActiveUserPosts($query)
    {
        return $query->whereHas('user');
    }
}

use App\Models\Post;

class PostController extends Controller
{
    public function index()
    {
        $posts = Post::activeUserPosts()->get();

        return view('posts.index', compact('posts'));
    }
}