Алексей Петров

SELECT
   `purchase_users`. *,
   `numbers`.`counter` 
FROM
    `purchase_users`
LEFT JOIN 
    (SELECT `track_code`, COUNT(*) AS `counter` FROM `purchase_users`  GROUP BY `track_code`) AS `numbers`
ON `purchase_users`.`track_code` = `numbers`.`track_code`