这条SQL语句在thinkphp（tp3）怎么写？

Question

SELECT * FROM goods t1,
(SELECT guanlian_id,COUNT(guanlian_id) as zhichishu from goods group by guanlian_id) t2
where t1.shenfen = 1 AND t2.guanlian_id = t1.id
order by rand() limit 2;

Answer 1

tp可以用原生的sql语句查询：
$re=M()->query($sql); //即可获得查询结果
当然，非读写分离的情况下，也可以用：
$re=M()->exec($sql);

Answer 2

你用的tp3还是tp5啊