Every time a user is registered I would like to set their username to be the row ID set in the user table (users).
I would like to do this as I have no reason for users to use the username field on my website as they need to sign in with their email address. So rather than having a random int assigned to them i thought it would make sense to use the row id.
Any help would be great thanks! I just wanted to choose the best approach.