$members=$model->query("
SELECT zhope_card.id AS Id,
zhope_card.cid AS Card_id,
zhope_user.name AS Card_name,
zhope_tpl.name AS Tpl_name,
zhope_cus.name AS Cus_name,
zhope_city.name AS Cus_city,
COUNT(zhope_cali.cid) AS Jz_count ,
DATE(MAX(zhope_cali.adddate)) AS Jz_last,
DATEDIFF(ADDDATE(CURDATE(), INTERVAL 1 YEAR),DATE(zhope_cali.adddate)) AS Jz_time
FROM zhope_card
LEFT JOIN zhope_user ON zhope_card.adduser=zhope_user.id
LEFT JOIN zhope_tpl ON zhope_card.tpl=zhope_tpl.id
LEFT JOIN zhope_cus ON zhope_card.woner=zhope_cus.id
LEFT JOIN zhope_city ON zhope_cus.aera=zhope_city.id
LEFT JOIN zhope_cali ON zhope_card.id=zhope_cali.cid
GROUP BY zhope_card.id
ORDER BY zhope_card.id;
");我这个SQL语句如果化为Thinkphp 的连贯操作，怎么写？~~~ 最佳答案
