select
    case
        when pay_method = '' then 'error'
        else pay_method
    end as pm,
    count(1) cnt
from
    user_client_log u
    left join product_info p on u.product_id = p.product_id
where
    product_name = 'anta'
    and step = 'select'
group by
    pm