php mysql查询3级分类下对应的一级和二级分类

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))