To whom was the opportunity to join the union offered?

I believe you are referring to Ulysses Grant. He was a great general, and the Union wanted him to command their troops. However, he decided to go with his native Virginia and became a confederate general.