select b.1,b.2,b.3,b.4,b.5,b.6,b.7,b.8,a.9,a. ······
from a
join (select 1 from b where b.id=) b on a. = b.
join (select 2 from b where b.id=) b on a. = b.
join (select 3 from b where b.id=) b on a. = b.
join (select 4 from b where b.id=) b on a. = b.
join (select 5 from b where b.id=) b on a. = b.
join (select 6 from b where b.id=) b on a. = b.
join (select 7 from b where b.id=) b on a. = b.
join (select 8 from b where b.id=) b on a. = b.
where ······

想把jion去了 或者给个更优化的方案