SELECT
a.*, count(1) AS rank
FROM
z_lihongen_temporary a
LEFT JOIN z_lihongen_temporary b ON a.po_mat_code = b.po_mat_code
AND a.ID <= b.ID
GROUP BY
a.po_mat_code,a.ID
ORDER BY
a.po_mat_code,a.ID
将要分组的字段作为left join 之后on 的条件再对此字段进行GROUP