我使用DB+record执行List<Record> list = Db.find(url,date,openId);语句，后台打印了sql语句：

SELECT a.*,b.result FROM sjb_main a
LEFT JOIN sjb_mortgage b on a.id = b.sjbId
LEFT JOIN (SELECT * FROM sjb_user WHERE openid =?) as c on b.userId = c.id  WHERE a.date = ? and a.state <2  ORDER BY time

但是list获取不到结果 
，我用这个sql在数据库执行时有两条数据，请问是什么原因呢？