I think the same can be achieved using the $attributes array in the model instead of the global scope or am I missing something @amshehzad?

@WendellAdriel Yes that would be right if I had the exact same attribute. I just added it here as an example,
Actual code was this:

static::addGlobalScope(fn(Builder $builder) => $builder
            ->when(
                is_null($builder->getQuery()->columns),
                fn(Builder $builder) => $builder->addSelect('*')
            )
            ->selectRaw('IFNULL((SELECT SUM(amount) FROM leave_transactions WHERE user_id = users.id), 0) AS leave_balance')
        );

@amshehzad oh got it!
Can’t you do that with an $appends attribute using the relation between the two models?

Thank you for reporting this issue!

As Laravel is an open source project, we rely on the community to help us diagnose and fix issues as it is not possible to research and fix every issue reported to us via GitHub.
If possible, please make a pull request fixing the issue you have described, along with corresponding tests. All pull requests are promptly reviewed by the Laravel team.

Thank you!