需要MySQL查询和PHP的帮助

I have the following 3 tables:

我有以下三张表:

(PK = Primary Key, FK = Foreign Key) (PK