Getting values from audit table

Hi I have table called-admission
mysql> DESC admission;
±-----------------------------±-------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±-----------------------------±-------------±-----±----±--------±------+
| id | char(36) | NO | PRI | NULL | |
| name | varchar(255) | YES | | NULL | |
| date_entered | datetime | YES | | NULL | |
| date_modified | datetime | YES | | NULL | |
| modified_user_id | char(36) | YES | | NULL | |
| created_by | char(36) | YES | | NULL | |
| description | text | YES | | NULL | |
| deleted | tinyint(1) | YES | | 0 | |
| assigned_user_id | char(36) | YES | | NULL | |
| admission_apprvd_by | varchar(40) | YES | | NULL | |
| admission_apprvd_date | varchar(40) | YES | | NULL | |
±-----------------------------±-------------±-----±----±--------±------+

The audit table for admission is admission_audit;
±--------------------±-------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±--------------------±-------------±-----±----±--------±------+
| id | char(36) | NO | PRI | NULL | |
| parent_id | char(36) | NO | MUL | NULL | |
| date_created | datetime | YES | | NULL | |
| created_by | varchar(36) | YES | | NULL | |
| field_name | varchar(100) | YES | | NULL | |
| data_type | varchar(100) | YES | | NULL | |
| before_value_string | varchar(255) | YES | | NULL | |
| after_value_string | varchar(255) | YES | | NULL | |
| before_value_text | text | YES | | NULL | |
| after_value_text | text | YES | | NULL | |
±--------------------±-------------±-----±----±--------±------+

My query is:
1.I want to know admission approval to a particular person by the role
2. The recored should be last inserted record of the role

Roles are:
1.AM
2.HM
3.RM
4.ZM

How to write the query for the above roles?

The approval will be given by all of them.
First Approval By AM,
Second Approval By HM,
Third Approval By RM

I want to know when
1.AM approved the approval
2.HM approved the approval
3.RM approved the approval

I have to get all this values from audit table.