In my project I need to send letter to user email with confirmation link.
My solution:
Add string column "code" and boolean column "is_active" (with default value false) to user table.
When user register, generate unique string key and save to database. Send to email link, for example host.com/user/email/{code}/confirm
Then find by the code (generated string value) user and set flag "is_active" - true.
Clear value of column "code".
How are you create confirmation link for email?