UPDATE ecs_member_price a,ecs_member_price b
SET a.user_price = b.user_price where b.user_rank = 4 and a.user_rank = 8 and a.goods_id = b.goods_id;
insert into ecs_member_price(goods_id,user_price,user_rank) select goods_id,user_price,7 from ecs_member_price where user_rank = 4;