SELECT
	A.USER_ID,
	U.USER_NAME,
	A.PV,
	A.PAY_TYPE,
	P.PV_PCS_FX,
	P.PV_PCS_FX_POINT
FROM
(SELECT
	O.USER_ID,
	O.PAY_TYPE,
	SUM(O.PV) AS PV
FROM
	AR_ORDER O
	WHERE O.PAY_TYPE = 'point' AND O.PERIOD_NUM = 160 GROUP BY O.USER_ID,O.PAY_TYPE ) A
	LEFT JOIN AR_USER U ON U.ID = A.USER_ID
	LEFT JOIN AR_PERF_PERIOD P ON P.USER_ID = A.USER_ID AND P.PERIOD_NUM = 160