select count(1),b.id from b where b.id in (select id from a where /可以查詢出25.26.27...
參考看看 https://youtu.be/CfmYngJX1KA