【magic-api】树形结构递归查询所有子节点

var  getChild = (parent_id, list)=>{

    var childList = db.select("""
        SELECT * FROM os_groups WHERE parent_id = #{parent_id}
    """);
    if (childList.size() > 0){
        for (item in childList) {
            list.add(item);
            getChild(item.id, list);
        }
    }else{
        return list;
    }

    return list;
}

return getChild("-1", []);