select
    if(pay_method='','error',pay_method) as pay_method,
    count(*) as cnt
from user_client_log u 
join product_info p on u.product_id=p.product_id
where product_name='anta' and pay_method is not null and step='select'
group by pay_method
order by cnt desc;