我正在为一个学校项目开发一个小
PHP框架,我正在学习如何构建ORM部分.
但是,我无法弄清楚如何从带有连接的SQL查询映射对象关系,或者我只是不知道要搜索的正确单词:(
t1
id
title
text
–
t2
id
name
description
我试着做一个简单的事:SELECT * FROM t1 LEFT JOIN t2 ON t1.id = t2.t1_id
我得到的是一个简单的数组,其中来自两个表和id列的所有字段都被覆盖,因为它存在于两者中.
[
"id" => "2"
"title" => "Lorem"
"text" => "Ipsum"
"name" => "Tomato"
"description" => "Tomato are nice"
]
所以我的问题是有一个简单的方法来获得这样的连接?
[
"t1" => [
"id" => 2
"title" => "Lorem"
"text" => "Tomato"
"t2" => [
"id" => 3
"name" => "Tomato"
"description" => "Tomato are nice"
]
]