用CI查询问题

q2326673

select COUNT(d.member_id),t.money from (SELECT `a`.`member_id`, sum(b.money) as money FROM `member` as `a`
LEFT JOIN `capital_log` as `b` ON `b`.`member_id`=`a`.`member_id` WHERE `b`.`type` = 4 GROUP BY `a`.`member_id`) as t
right join member as c on t.member_id = c.member_id LEFT JOIN member as d on c.member_id = d.parent_id GROUP BY c.member_id ORDER BY t.money desc 这样的语句 请问用CI的查询方法要怎么写

Closer

先試著看 CI 手冊 - 查询构造器类 吧
嘗試過後，再來討論你遇到的障礙