Tencent
一对多表关联的输出问题的咨询
想咨询下APIJson5.1.5对于一对多表关联时，它的子表输出的问题；
请求报文如下：
{ "format": true, "[]": { "join": "&/BFM_MENU_DIR/DIR_ID@", "BFM_DIR": { "@column": "DIR_ID,DIR_NAME,PARENT_ID,ICON_URL,STATE,STATE_DATE,DIR_CODE", "STATE_DATE>=": "2018-10-16", "STATE_DATE<=": "2018-10-17 14:00:00", "STATE":"A" }, "BFM_MENU_DIR": { "@column": "MENU_ID,DIR_ID,STATE,STATE_DATE", "DIR_ID@": "/BFM_DIR/DIR_ID", "STATE":"A" }, "query": 2 }, "total@": "/[]/total" }
这个是一个目录和菜单的关联查询，一个目录下有多个菜单数据，但是APIJson返回的报文，对于菜单表BFM_MENU_DIR，同一个目录，返回的关联数据都是第一条数据，想咨询要如何处理，可以返回子表的其它数据；
例如返回： {"list":[{"bFM_DIR":{"DIR_ID":1,"DIR_NAME":"User & Role Management","ICON_URL":"iconfont icon-system-mgr","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":2,"DIR_ID":1,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":1,"DIR_NAME":"User & Role Management","ICON_URL":"iconfont icon-system-mgr","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":2,"DIR_ID":1,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":1,"DIR_NAME":"User & Role Management","ICON_URL":"iconfont icon-system-mgr","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":2,"DIR_ID":1,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":4,"DIR_NAME":"Privilege Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":5,"DIR_ID":4,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":4,"DIR_NAME":"Privilege Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":5,"DIR_ID":4,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":4,"DIR_NAME":"Privilege Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":5,"DIR_ID":4,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":4,"DIR_NAME":"Privilege Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":5,"DIR_ID":4,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":4,"DIR_NAME":"Privilege Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":5,"DIR_ID":4,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":4,"DIR_NAME":"Privilege Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":5,"DIR_ID":4,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":4,"DIR_NAME":"Privilege Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":5,"DIR_ID":4,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":4,"DIR_NAME":"Privilege Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":5,"DIR_ID":4,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":4,"DIR_NAME":"Privilege Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":5,"DIR_ID":4,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":4,"DIR_NAME":"Privilege Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"},"bFM_MENU_DIR":{"MENU_ID":5,"DIR_ID":4,"STATE":"A","STATE_DATE":"2018-10-17 03:37:47.0"}},{"bFM_DIR":{"DIR_ID":12,"DIR_NAME":"Staff & Organization Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:49.0"},"bFM_MENU_DIR":{"MENU_ID":13,"DIR_ID":12,"STATE":"A","STATE_DATE":"2018-10-17 03:37:49.0"}},{"bFM_DIR":{"DIR_ID":12,"DIR_NAME":"Staff & Organization Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:49.0"},"bFM_MENU_DIR":{"MENU_ID":13,"DIR_ID":12,"STATE":"A","STATE_DATE":"2018-10-17 03:37:49.0"}},{"bFM_DIR":{"DIR_ID":12,"DIR_NAME":"Staff & Organization Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:49.0"},"bFM_MENU_DIR":{"MENU_ID":13,"DIR_ID":12,"STATE":"A","STATE_DATE":"2018-10-17 03:37:49.0"}},{"bFM_DIR":{"DIR_ID":12,"DIR_NAME":"Staff & Organization Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:49.0"},"bFM_MENU_DIR":{"MENU_ID":13,"DIR_ID":12,"STATE":"A","STATE_DATE":"2018-10-17 03:37:49.0"}},{"bFM_DIR":{"DIR_ID":12,"DIR_NAME":"Staff & Organization Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:49.0"},"bFM_MENU_DIR":{"MENU_ID":13,"DIR_ID":12,"STATE":"A","STATE_DATE":"2018-10-17 03:37:49.0"}},{"bFM_DIR":{"DIR_ID":19,"DIR_NAME":"Bulletin Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:50.0"},"bFM_MENU_DIR":{"MENU_ID":20,"DIR_ID":19,"STATE":"A","STATE_DATE":"2018-10-17 03:37:50.0"}},{"bFM_DIR":{"DIR_ID":19,"DIR_NAME":"Bulletin Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:50.0"},"bFM_MENU_DIR":{"MENU_ID":20,"DIR_ID":19,"STATE":"A","STATE_DATE":"2018-10-17 03:37:50.0"}},{"bFM_DIR":{"DIR_ID":19,"DIR_NAME":"Bulletin Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:50.0"},"bFM_MENU_DIR":{"MENU_ID":20,"DIR_ID":19,"STATE":"A","STATE_DATE":"2018-10-17 03:37:50.0"}},{"bFM_DIR":{"DIR_ID":19,"DIR_NAME":"Bulletin Management","STATE":"A","STATE_DATE":"2018-10-17 03:37:50.0"},"bFM_MENU_DIR":{"MENU_ID":20,"DIR_ID":19,"STATE":"A","STATE_DATE":"2018-10-17 03:37:50.0"}}],"total":22,"ok":true,"code":200,"msg":"success","sql:generate|cache|execute|maxExecute":"24|18|6|1000","depth:count|max":"0|5","time:start|duration|end|parse|sql":"1658409399543|1833|1658409401376|745|1088"}
一个目录对应的菜单，都是菜单的第一条数据。
