Query to get the manager name form manage department

I need to retrieve the manager name(reporting name) in manage departments page under organization department name of fusion as below attached.
I need the rest APIs to fetch this information or sql query .I am unable to get this information.

Can anyone please share the query or rest APIs

Thanks in Advance