1、希望結果:[
{ "created_at": "Wed Jun 01 00:50:25 +0800 2011", "id": 12438492184, "name": "love your work.......", "user": { "id": 1404376560, "name": "zaku", "url": "http://blog.ceshi.com.cn/zaku"
},
},
{ "created_at": "Wed Jun 01 00:50:25 +0800 2011", "id": 12438492185, "name": "love your work.......", "user": { "id": 1404376561, "name": "測試", "url": "http://blog.ceshi.com.cn/zaku"
},
},
],有表:article和user2、通過關聯user表查詢得到希望結果,sql查詢語句怎么寫?(注:不是將查詢結果再通過foreach組裝得到,要求通過一條sql就搞定)
添加回答
舉報
0/150
提交
取消