Question about MySQL Association query?

There are currently three tables: ABCA and B,. uidB. relationship between idB and C, B. uidC. id: If you want to query table A directly using A MySQL statement, you can query the information of table C through Table B, such as leftjoin, please give me a demo SQL statement... there are currently three tables:

There are: A B C

Relationship between A and B, A. uid = B. id

Relationship between B and C, B. uid = C. id

If you want to use A MySQL statement to directly query table A, you can use Table B to check the information of table C, such as left join. please give me A demo SQL statement. thank you.

Reply content:

There are currently three tables:

There are: A B C

Relationship between A and B, A. uid = B. id

Relationship between B and C, B. uid = C. id

If you want to use A MySQL statement to directly query table A, you can use Table B to check the information of table C, such as left join. please give me A demo SQL statement. thank you.

For reference only

SELECT * from a left join B on a. uid = B. id left join c on B. uid = C. id WHERE...