Sir Keir Starmer will not stand down and remains "upbeat and confident" despite his second top aide quitting in less than 24 hours.