MySQL查出多维数组_php – 将MySQL查询作为多维数组返回

我有一个SQL查询,我做了一些连接,但是当我在

PHP中var_dump结果时,我得到一个数组,有很多重复.有没有办法将结果作为多维数组返回,如：

array( array("projectname", "projectdescription", "projectthumb" , "activestate"),

array("img1.jpg", "img2.jpg", "img3.jpg"),

array("tech1", "tech2", "tech3")

);

SQL查询：

SELECT p.name,

p.description,

p.img_thumb,

p.active,

t.name,

i.filename

FROM projects as p

JOIN projects_x_techs as pt

ON p.id = pt.project_id

JOIN techs as t

ON pt.techs_id = t.id

JOIN images as i

ON p.id = i.projects_id

WHERE p.slug = :slug

ER图