Use wp_update_user to update custom column in wp_users table
It is not a good practice to add/remove columns to/from the core tables in WordPress. There is no guarantee that the very next update doesn’t change this table’s behavior, or even overwrite your column. Your best approach is to use metadata as you mentioned. But, if you need to do this for some reason, you … Read more