SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users LEFT JOIN user ON (users.referrerid = user.userid) WHERE users.referrerid <> 0 AND user.userid NOT IN (0) GROUP BY users.referrerid ORDER BY referrals DESC