Is there a way to get the cardinality between tables, from a MySQL database?
What I understood from your question is that you need to list all the parent and child relationship in your database, for that you can execute below query

SELECT 
    ke.referenced_table_name 'parent table',
    ke.referenced_column_name 'parent column',
    ke.table_name 'child table',
    ke.column_name 'child column',
    ke.constraint_name
FROM
    information_schema.KEY_COLUMN_USAGE ke
WHERE
    ke.referenced_table_name IS NOT NULL
        AND table_schema = 'your_db_name'
ORDER BY ke.referenced_table_name;


Here your_db_name is my database.