mysql父子类排序|根据条件排序

select *
from `position`
where position_isshow=1
order by if(position_pid=0,position_id,position_pid),position_id