有没有办法在以下json格式中找到sql结果？

I have two tables tblOne and tblTwo. tblOne Table contains values like

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

tblTwo Table contains values like

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

is there any way to get result in following json format:

{
{
"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"}
            ]
}
}