MySQL sorts and serial numbers by field A with the same number as the field a value

select  a.test,b.* from (select @y:[email protected]+1 as test,a.* from (select * from resourcecenter.cm_identify_relation a  group by a.issue_party   ) a,(select @y:=0) d order by issue_party) a,resourcecenter.cm_identify_relation b where a.issue_party=b.issue_party order by b.issue_party

First, create a group sort of field a in the table and increment the sequence number,
Then use the original table to assign a value based on field a, and display the added ordinal column

MySQL sorts and serial numbers by field A with the same number as the field a value