樹狀結構查詢

ancestor FROM member WHERE ancestor REGEXP  '^12$|,12$|,12,|^12,'

查詢所有下級：

 SELECT seq_id,parent_id,member.ancestor FROM member WHERE ancestor REGEXP  '^1$|,1$|,1,|^1,'

查詢下級，下下級：

SELECT seq_Id ,parent_id,member.ancestor FROM member WHERE ancestor REGEXP  '^1$|^1,[0-9]*$|,1$|1,$'