SELECT
    SUBSTRING_INDEX(order_id,'_',-1) product_id,
    COUNT(DISTINCT SUBSTRING_INDEX(order_id,'_',1)) cnt
FROM order_log
GROUP BY SUBSTRING_INDEX(order_id,'_',-1)