{
"OrdersInfoList" : [{
"PlanInfoList" : [{
"StagePlanNo" : "BT202002240000180600,"
"ExceedStatus" : "M1"
}, {
"StagePlanNo" : "BT202002240000180601,"
"ExceedStatus" : "M0"
}, {
"StagePlanNo" : "BT202002240000180602,"
"ExceedStatus" : "M0"
},
"AccountNo" : "01316150417801",
"Bank", "CITICCFC"
}]
}

How to use HQL parsed into two tables