I am thinking if I can resolder the feet it should work
You should also aim to resolder the outermost two of the five pins (negative and positive) or it likely won't work well enough. You should get away with simply applying just enough heat to melt the solder.
The other thing you could do is cut the plug off the USB cable and solder the wire directly to the board. The two flat gold pads just above the socket in your photo are negative (left) and positive (right). Connect the black (negative) and red (positive) wires to these points and it should charge.
You should also aim to resolder the outermost two of the five pins (negative and positive) or it likely won't work well enough. You should get away with simply applying just enough heat to melt the solder.
The other thing you could do is cut the plug off the USB cable and solder the wire directly to the board. The two flat gold pads just above the socket in your photo are negative (left) and positive (right). Connect the black (negative) and red (positive) wires to these points and it should charge.