我需要一个返回集合到paginate但我只能返回数组,因为查询使用自然的JOIN . 如何使用Laravel集合执行此查询:
SELECT mensagens . * FROM mensagens NATURAL JOIN(SELECT id_emissor,MAX(created_at)created_at FROM mensagens WHERE id_receptor =“ . $ user_id . ”GROUP BY id_emissor)t
我用过这段代码:
$ mensagem = \ DB :: select(DB :: raw(“SELECT mensagens . * FROM mensagens NATURAL JOIN(SELECT id_emissor,MAX(created_at)created_at FROM mensagens WHERE id_receptor =” . $ user_id . “GROUP BY id_emissor)t” ));
1 回答
如果您想使用您的查询,那么请使用如下 -
否则你也可以使用雄辩 .