连表查询 子查询/连接查询

 select sum(a.money)overage,
    (select sum(b.money) from deer_bonus b where a.user_id = b.user_id and entr_time <=   #{date}) rewardn,
    (select sum(c.prcie) from deer_order_details c where a.user_id = c.user_id)consume,
    (select sum(d.money) from deer_recharge d where a.user_id = d.user_id) recharge
    from
    deer_wallet a



select
    (select max(c.user_name)from deer_user c where b.higher_user_id = c.id) name,
    a.order_id orderId,
    a.user_id userId,
    a.active active,
    a.higher_user_id higherUserId,
    a.prcie prcie,
    a.remarks remarks,
    a.create_time createTime,
    b.user_name userName
    from
    deer_order_details a
    left join deer_user b on ( b.id = a.higher_user_id and a.user_id = b.higher_user_id )
    where a.user_id = #{id}  and a.status = 1;