SELECT *FROM `affiliate`
SELECT referer, COUNT(id) AS cnt FROM mirrormx_customer_chat_talk WHERE referer IS NOT NULL GROUP BY referer ORDER BY referer ASC
Array ( )