I want to create a sign up using unique username

[mikeloc]

The second thread has both of the answers you need (use slugs or do a count of a search), and if you can’t get the latter to work, it is likely because the default privacy rule on the User data type is getting in the way of the search.