select * from a left join b on a.aid = b.bid and a.aid = 3 等于 select * from a left join b on a.aid = b.bid where a.aid = 3 or a.aid is null