Need Approver ID and Name for particular CR from back-end database, which table or view has this info.
check most table related CHANGE_REQUESTS, did not find approver details.
Get the WORKITEM_ID from CHANGE_REQUEST and do a join to CHANGE_REQUEST_WORK_USER to get the ID of the appover
Hope that helps
Retrieving data ...