The Basic concept of the double opt in system is what you are after, with the only difference that the email does not go to the user who registers, but goers to the site admin.
or you could not send the verification link at all, and instead update that column value manually in the database.
How that column gets changed (By a link set to the user or manually by the admin) is the only difference to the double opt in system.