mysql 遞歸查詢:mysql實現遞歸查詢[朗讀]

withaas(select*fromtable1whereparentid=0unionallselectb.*froma,table1bwherea.id=b.parentid)select*froma用withas來實現遞歸。