Dependent 2 queries on "same" column in Mysql-CodePudding

I have a table like below

report_code | result_of_report
_______________________________
Rpx-34512-00| rejected
Rpx-34512-01| rejected
Rpx-34512-02| rejected
Rpt-22433-00| rejected
Rpt-22433-01| rejected
Rpt-22433-02| rejected
Rpt-22433-03| rejected
Rpt-22433-04| rejected
Rpt-22433-05| rejected
Rpt-22433-06| accepted
Rcs-34555-00| rejected
Rcs-34555-01| rejected
Rcs-34555-02| accepted

And this is what I want to get: For report_code I need to substr(report_code, 4,5) to 5 digit report code and look for reports that haven't yet accepted.

6th revision (it doesn't matter which version accepted btw.) of 22433 has a record of accepted. So it passed. 34555 get accepted in second revision. It passed too. BUT 34512 doesn't have any accepted record. I want to list all records like 34512 but with groups. So I don't want to list many duplicated line. To make it more clear, no need to list 34512 3 times. One will be enough.

First of all I want to explain what I tried. I know it doesn't the right way but it was a temporary solution for me.

I ran a loop to take where result_of_report='rejected' and inside this loop, I took that 5 digit report_code as $code and I used that code in a loop as where(report_code, 'like', '$code) AND where(result_of_report, '=', 'accepted') inside of the first one to make query for every record.