Originally Posted by pornRefinery

RewriteEngine on
RewriteRule ^/p/([^/]+) /profile.php?user=$1

Will redirect domain.com/p/john to the page you want. It's better to do it under /p/ or any other name you choose as opposed to the root dir.