楼主是想这样访问的吗?
http://example.com/~user/
建议参考一下这儿的:
http://httpd.apache.org/docs/2.0/mod/mod_userdir.html