well if your using any version over 5.0 you can do this
UPDATE pp_photos SET userid=1, user='dude' WHERE userid=2
which of course you replace userids to the respective ones you want to use above it simply means every photo owned by userid 2 will be changed to userid 1 and of course you might want to update the user's name at the same time
Query Photo Owner Change 
Linear Mode
