三张表

a表 pid wid

b表 id

c表 id


三表之间关系

a.pid =b.id

a.wid = c.id


a 表 例子

pid wid
1 6
1 2
1 1

根据 get['id'] = 6

去查询 b表 筛选掉 pid=1 并且 wid = 6 的这个人。

SELECT a.* FROM rt_pingwei AS a WHERE a.id NOT IN (SELECT b.pid FROM rt_pwwork AS b , rt_work AS c WHERE b.`wid` = c.`id`)