WPW Active Subs

SELECT COUNT(sub.user_id) AS subscribers, plan.title
FROM xiszt_payplans_subscription sub
LEFT JOIN xiszt_payplans_plan plan ON plan.plan_id = sub.plan_id
WHERE sub.STATUS = 1601
GROUP BY sub.plan_id;