通过contract_project做中间表就行：select *from contract_project aleft join project b on a.projectId = b.projectIdleft join contract c on a.contractId = c.contractId前提是contract_project要大而全，包含所有的pid和cid，不然不行
