SELECT
	SUM(E.提现金额) AS 提现金额,
	SUM(E.手续费) AS 手续费,
	SUM(E.实际到账金额) AS 实际到账金额
	FROM(
	SELECT
		A.USER_NAME AS 会员编号,
		W.AMOUNT AS 提现金额,
		W.FEES AS 手续费,
		W.REAL_AMOUNT AS 实际到账金额,
		W.AUDIT_STATUS AS 提现状态,
		FROM_UNIXTIME(W.AUDITED_AT,'%Y-%m-%d %H:%i:%S') AS 审核时间
	FROM  AR_WITHDRAW W LEFT JOIN AR_USER A ON W.USER_ID = A.ID ) E
	WHERE E.提现状态 = 2 AND E.审核时间 >= '2021-06-01 00:00:00' AND E.审核时间 < '2021-07-01 00:00:00'