Merging users

My client had 5 private clubs on a multi-site installation. Three of the clubs didn't attract enough interest so he wants to combine those three into one club. Obviously I can't just import two in to one because of the primary ID.
Is there a way to merge those 3 subdomain memberships into one without having to manually change the ID on all necessary tables? Is there any way to automate it?