select a1,a2,a3,b2
from a
left join
(
select b1,min(b2) as b2 from b group by b1
)
b on a1=b1

如果b1,b2,b3,b4存在重复的b1,b2(但b3,b4不一样)还有麻烦一点