请教一个数据库的model

for

如下面的 sql 语句

SQL复制代码

 
SELECT realname AS name, tel AS tel, (SELECT daname FROM `allset` WHERE `to` = a.KEY AND allset.del=0 ORDER BY allset.id DESC LIMIT 0,1) AS dnam,  (SELECT times FROM `allset ` WHERE `to` = a. KEY AND allset.del=0 ORDER BY allset.id DESC LIMIT 0,1) AS TIME FROM student a WHERE KEY = '1234'
 

复制代码

得到

name  tel  dnam time

请问如果用查询构造器的类来写，该怎么写呢？

Hex

复杂 SQL 不建议用 QueryBuilder 来写，另外 QueryBuilder 也不是万能的。