select A.*,
(case when B.id is null then false else true end) as choosed
from A left join B on A.id=B.A_id where ......
choosed字段为true,则A.item在B表中存在,choosed字段为false,则在B表中不存在
select A.*,
(case when B.id is null then false else true end) as choosed
from A left join B on A.id=B.A_id where ......
choosed字段为true,则A.item在B表中存在,choosed字段为false,则在B表中不存在