SELECT
    IF(pay_method = '', 'error', pay_method),
    COUNT(pay_method) AS cnt
FROM user_client_log u
JOIN product_info p
ON u.product_id = p.product_id
WHERE product_name = 'anta' AND step = 'select'
GROUP BY pay_method
ORDER BY cnt DESC