Find user profile page link from database
The path "/users/admin" is actually an "alias" for something like "user/1", where 1 is the user id. In Drupal 7, these aliases are stored in the {url_alias} table along with the real path that they point to.

So if you want to figure out what user the alias "users/admin" points to, look in the {url_alias} table and you will see a column called "source", which should have something like "user/1". "1" in this example is the user id.