Mysql how to access to foreign data with python

hi all,
I have a mysql database written in phpmyadmin. I have a table of clients and for each clients i would set a table of their data. In clients table I set “id” as “primary” and in data tables I have the column called id_client with foreign “id” columns in clients table.

in python I would call clients and reach the data table associate to that client

----
clients
-----
1 --> data table row with id_client = 1
2 --> data table row with id_client = 2 
3 --> data table row with id_client = 3

to clarify what I would like to do: if I choose a client I would like read easily its data store in data table.

it is possible?
many thanks in advance