laravel-eloquent-scope-as-select

Stop duplicating your Eloquent query scopes and constraints in PHP. This package lets you re-use your query scopes and constraints by adding them as a subquery. Maintained by protonemedia on GitHub, where it has earned 143 stars from the community.

It's actively developed around laravel, php, subquery, and is a solid reference for anyone building with these tools.