Laravel Eloquent Scope As Select Laravel Package

protonemedia/laravel-eloquent-scope-as-select

Laravel Eloquent Scope as Select lets you add local scopes as select subqueries, so aggregated or computed values from related models come back in a single query. Skip extra database hits and N+1 problems while keeping your models clean and readable.