Update nodes as C inner join ( select sum(amount) as total , user_id from bimeh_commission group by user_id ) as A on C.user_id = A.user_id set C.total_amount = A.total
Update nodes as C inner join ( select sum(amount) as total , user_id from bimeh_commission group by user_id ) as A on C.user_id = A.user_id set C.total_amount = A.total