UPDATE member m
INNER JOIN trade t ON m.uid = t.uid
AND t.date_y = '.$y.'
AND t.date_m = '.$m.'
LEFT JOIN (
SELECT
count(*) AS c_num,
puid
FROM
member
WHERE
group_id >= 5
GROUP BY
puid
) manum ON manum.puid = m.uid
SET m.group_id = 6
WHERE
c_num >= 2
AND c_num < 3
AND t.trade_amount BETWEEN '.$v[' min '].'
AND '.($v[' max '] - 1)