Logging in is done through a POST request, but clicking on a link results in a GET request, so that won't work.
What you could do: Provide a link to a page that offers a login form and redirects them to their profile page once they've logged in. All the code you would need for such a script could be lifted from users.php.
bye, Dirk