Count with Condition in laravel Eloquent

Question

I want to count users who have stripe_plan = platinum_monthly

$platinum=User::count('stripe_plan','platinum_monthly');

But its returning all users who have selected any available plan how to solve this issue need help?

Answer 1

Try adding the condition in a where clause

$platinum=User::where('stripe_plan','platinum_monthly')->count();

Answer 2

$platinum = User::where('stripe_plan', 'platinum_monthly')->count();

You have to select the users you want to count, not "count the users you want to count".