1.包括根节点:
select postname
from jxd7_rm_post
start with postid = ?
connect by prior postid = parentid;
2.不包括根节点:
select postname
from jxd7_rm_post
start with parentid = ?
connect by prior postid = parentid