php - 有没有办法找到以下json格式的sql结果？

Question

我有两张表 tblOne 和 tblTwo。tblOne 表包含如下值

**Id Amount TotalReceipt**
1  1000   2
2  2000   3

tblTwo 表包含如下值

**Id tblOneId ReceiptNo**
1  1        001
2  1        002
3  2        003
4  2        004
5  2        005

有什么方法可以得到以下 json 格式的结果：

{
{
"Id":"1",
"Amount":"1000",
"TotalReceipt":"2",
"ReceiptDetail":[
            {"Id":"1","tblOneId":"1","ReceiptNo":"001"},
            {"Id":"2","tblOneId":"1","ReceiptNo":"002"}
            ]
},
{
"Id":"2",
"Amount":"2000",
"TotalReceipt":"3",
"ReceiptDetail":[
            {"Id":"3","tblOneId":"2","ReceiptNo":"003"},
            {"Id":"4","tblOneId":"2","ReceiptNo":"004"},
            {"Id":"5","tblOneId":"2","ReceiptNo":"005"}
            ]
}
}

标签： phpjsonsql-serversql-server-2012