How to list all the inherited tables from the parent table?
Try this:

SELECT
table_name
FROM information_schema.KEY_COLUMN_USAGE
WHERE table_schema = 'database_name'
AND referenced_table_name = 'user';


This will list of referenced tables under table 'user'.