SELECT LPAD(' ', 4*(LEVEL-1)) || board_name, allow_usergroup FROM tb_bi_tree START WITH bbsid='000' CONNECT BY PRIOR bbsid=upper_bbsid;