mysql数据库
sql语句:现在是查出数据库id=1即 单机类型下所有的2级和3级分类
select * from category where id=1 or pid IN(SELECT id from category where id=1) OR
pid IN( SELECT id from category where pid in(SELECT id from category where id=1))
mysql数据库
sql语句:现在是查出数据库id=1即 单机类型下所有的2级和3级分类
select * from category where id=1 or pid IN(SELECT id from category where id=1) OR
pid IN( SELECT id from category where pid in(SELECT id from category where id=1))