select p_name,w_name from p_jichan as a left join jichan as b on b.tp_id = a.tp_id left join jichan_w as c
on c.tp_id = b.tp_id where a.p_name = "杯子" group by w_name
on c.tp_id = b.tp_id where a.p_name = "杯子" group by w_name
from p_jichan a
left join jichan b on b.tp_id = a.tp_id
left join jichan_w c on c.tp_id = b.tp_id
where a.p_name = "杯子"
group by a.w_name
select p_name,w_name
from p_jichan as a
left join jichan as b on b.tp_id = a.tp_id
left join jichan_w as c on c.tp_id = b.tp_id
where a.p_name = "杯子"
group by p_name,w_name
from p_jichan as a
left join jichan as b on b.tp_id = a.tp_id
left join jichan_w as c on c.tp_id = b.tp_id
where a.p_name = '杯子' group by w_name