Get WP database Information on static PHP page

Hello everyone.

This is something I’ve been trying to do for a very long time:

Basically, I want to create a splash page that retireves user information from people who have registered on my site and posts it there.

Jonh Doe registers with my site and his username is jonhdoe

That piece of information is placed on the DB as ´$wp_user = jonhdoe´ for example.

I have the HTML page with lots of banners, text and images and I want to put in links on them like:

http://example.com/$wp_user = jonhdoe

which is parsed by Apache or whatever as

http://example.com/jonhdoe

In a nutshell, I’m trying to reverse engineer the following site’s page:
http://ptcprofessor.com/affiliateban.php?rid=32476

Sorry for the Affi link but it’s part of my project. Also, I don’t recommend joining.

They register on my site, enter their details and then get a custom page for them using their WP details.

The problem is that the page is only available with their details when they are logged in and not in a permanent manner.

Do I need a rotator or something? please advise… I probably made a poor choice of words but this is the gist of what I need. Thank you