递归查询

"parentId": {
      "tableId": 1,
      "field": "parentId",
      "dataType": "varchar",
      "title": "上级菜单",
      "remark": "上级菜单编码，GUID，为空表示一级菜单  测试递归查 询 ",
      "name": "parent_id",
      "alias": "parent_id",
      "isSearch": true,
      "isData": true,
      "filter": {
        "method": "iteration",
        "sql": " and menu_id in @parentId",
        "tableName": "bo_sys_menu",
        "whereSql": " ",
        "iterationId": "menu_id",
        "iterationParentId": "parent_id",
        "dbRead": null
      },
      "editPropertie": {
        "showMethod": "text",
        "type": null,
        "format": null,
        "first": [
          {
            "name": "请选择",
            "value": null
          }
        ]
      },
      "pagePropertie": {
        "showMethod": "text",
        "type": null,
        "format": null,
        "first": [
          {
            "name": "全部",
            "value": null
          }
        ]
      },
      "listPropertie": {
        "isOriginal": true,
        "isSn": true,
        "showMethod": "text",
        "type": null,
        "format": null,
        "first": [
          {
            "name": "全部",
            "value": null
          }
        ]
      },
      "dimJoin": {
        "fromDimField": "menu"
      },
      "maxLength": 36
    },