MySQL recursively queries the current node and Its subnodes

MySQL recursively queries the current node and subnode 1. Table Structure 2. query statements

Create procedure Pro_GetUnderOrg (in idd varchar (36) begindeclare levint; set lev= 1; drop table if exists tmp1; create table tmp1 (id varchar (36 ), orgName varchar (50), ParentID varchar (36), levv INT); INSERT tmp1 select id, OrgName, ParentID, 1 FROM 'organization' WHERE ParentID = idd; while row_count ()> 0do set maid; INSERT tmp1 SELECT t. ID, t. 'orgname', t. 'parentid', levfrom organization t join tmp1 a on t. parentId =. id and levv = lev-1; end while; INSERT tmp1 select id, OrgName, ParentID, 0 FROM 'organization' where id = idd; SELECT * FROM tmp1; end;

 

3. call Pro_GetUnderOrg ('9b2ae044-3B51-47FA-A24C-8326BA7B9FD3 '); 4. Note: After designing this table, you must add a path field so that you don't have to worry about it.