如何把数据库读出来的List<Object> 转成特殊结构的json

表结构PHY_TEST

timestamp ip role localifindex localifname peerifindex peerifname peerip band

用sql 语句查询得出四条数据
selecet * from PHY_TEST where timestamp =''2018-10-12'
返回的是List
timestamp ip role localifindex localifname peerifindex peerip band

2018-10-12 192.168.1 gw 1 ifname 21 192.168.10 10%

2018-10-12 192.168.1 gw 2 ifname 22 192.168.11 1%

2018-10-12 192.168.1 gw 3 ifname 23 192.168.12 6%

2018-10-12 192.168.2 gt 1 ifname 2 192.168.20 19%

把这些数据整理成这样结构的json

{
"physical":{
"timestamp":"2018-10-12"
"node":[
{“ip”:“192.168.1”
"role":"gw"
"neighbor":[
{"local_ifindex":"1"
"local_ifname":"ifname"
"peer_ifindex":"21"
"peer_ip":"192.168.10"
"band":"10%"
},
{"local_ifindex":"2"
"local_ifname":"ifname"
"peer_ifindex":"22"
"peer_ip":"192.168.11"
"band":"1%"
},
{"local_ifindex":"3"
"local_ifname":"ifname"
"peer_ifindex":"23"
"peer_ip":"192.168.12"
"band":"6%"
}]},
{“ip”:“192.168.2”
"role":"gt"
"neighbor":[
{"local_ifindex":"1"
"local_ifname":"ifname"
"peer_ifindex":"2"
"peer_ip":"192.168.20"
"band":"19%"
},
}
]
},
}

        求解，，，急急急 懂得指导一下

https://blog.csdn.net/liujianshui/article/details/41048489