SELECT classFROM B WHERE name = (select name from A where id = xxxx)即可如果一个id对应多个nameSELECT classFROM B WHERE name IN (select name from A where id = xxxx)
