Create one-use post dynamically, add to main query, do not insert post (user profile view)

From what I understand you are trying to change the permalink structure of the user, so instead of showing yoursite.com/author/yourusername it will show yoursite/profile/yourusername?

You can add a rewrite rule to the permalink structure to make that change:

function yourdomain_user_rewrite() {
    global $wp_rewrite;
    $wp_rewrite->author_base="profile";
    $wp_rewrite->author_structure="https://wordpress.stackexchange.com/" . $wp_rewrite->author_base . '/%author%';
}

add_action( 'init', 'yourdomain_user_rewrite' );

Then Worpdress will automatically load author.php on your theme when yoursite/profile/XXXX is queried. No complicated queries involved!

Is that what you are looking for?

Related Posts:

  1. Getting all user metadata from user
  2. How to add custom query filters in WP_User_Query
  3. Add a default meta_value to new posts
  4. Filter user list that meta_value is empty
  5. Query wp_usermeta alongside wp_users
  6. SQL User Query by Multiple Roles using PHP
  7. WP User Query get all authors with last name starting with specific letter
  8. Sort users by “birthday” using WP_User_Query
  9. Hide Administrators From User List except current user (administrator)
  10. How to display user order by role
  11. Import wp users via one click demo option
  12. Dynamic User Id
  13. Prevent author bio page from showing in search results
  14. Get multiple users with meta value in one query and populate WP_User class
  15. Reduce number of SQL queries inside WP_Query loop to fetch author data
  16. Display if author page is author page of current user
  17. Get user first name from custom endpoint
  18. Storing an array of objects related to each user
  19. Query to get last posts from authors of blog
  20. Deleting terms from the WordPress wp terms table
  21. Query pages created by deleted users
  22. Query posts by post type, author and post meta
  23. Random users always showing same 8 users
  24. wp_set_object_terms() custom taxonomy not working correctly when using insert post
  25. Set “editor” role to existing user
  26. wp_insert_post with ACF Fields and WP Meta Query returns no rows until update
  27. How to query 5 users in random who have published more than 10 posts
  28. How to query users by post count no less than 10
  29. Merge wp-query and get_users
  30. Get all wp_users sort by metakey
  31. Logging search queries for logged-in users
  32. List users by Year of Birth using a foreach loop to dynamically populate years and data
  33. Show subscriber id in loop
  34. Wrote a WP Cron Plugin and it triggers a fatal error upon activation
  35. Query Users by post count, last 30 days and display each users post count according to post type
  36. Get users query makes the site loading time too big?
  37. Get all user with both meta_value
  38. Group users by meta field, with name of meta field as group title
  39. Gallery shortcode numerical sorting
  40. Is there a reason why Pages are not publicly_queryable?
  41. Check return value of get_posts
  42. How Can I Change The Tax Query For The Main Loop For Taxonomy Archives?
  43. Exclude some authors from query
  44. The most effective way to split by post type in custom query?
  45. Get a list of posts by specific category
  46. WordPress Query String: get_posts(‘cat=5’) vs WP_Query( ‘cat=5’) vs URL: /site/?cat=5
  47. apply custom where to the default $wp_query
  48. WP_Query – Adding “offset” posts to the end of the loop
  49. wp_query serialised array
  50. Multiple wordpress queries with nested output (odd – even)
  51. Using Transients
  52. it’s possible make a WP_Query with math operations?
  53. show posts with range meta key
  54. how to write wordpress query for multiple metakeys checking?
  55. Sorting search results with custom dropdown
  56. wp_query get attachments in larger size
  57. Force WordPress to be more random
  58. Show posts of an advanced search form
  59. Query using string from custom field as array value
  60. Category based on post id
  61. posts_per_page is not working
  62. Widget only in first post
  63. Query WP Page for Buddypress Group Home [closed]
  64. WP Query orderby ACF boolean values and ACF field value
  65. How to separate two columns from one content on a page template?
  66. Get Post Title from different post type based on current loops post_parent using
  67. How can I order a post query’s results based on the number of matching taxonomy terms?
  68. wp query to use both author id and meta_query
  69. How to make the WP query search for the “s” arg in other places too
  70. WP_Query for a taxonomy value OR a custom post type meta field
  71. WP_query pagination on frontpage
  72. WordPress Query by Category using Post Slug
  73. Select multiple categories with is_tax
  74. Display Search Results by tag_ID in my search.php
  75. Repeat array inside array through while loop
  76. What’s causing an infinite loop?
  77. pages shortcode filtering by category
  78. How to set up pagination for a custom loop on a global template (author.php, tag.php, archive.php?)
  79. Ignoring ‘a’ when sorting posts
  80. Issue generating custom filter for cpt admin columns
  81. Duplicate a Query Built with PHP and Mysql but now in WordPress
  82. UPDATED: Save a custom_field value when automatically creating a post using wp_insert_post
  83. How to take parameters from a function and make them editable as attributes in a shortcode
  84. What method does this eventually call: do_action_ref_array( ‘parse_query’, array( &$this ) );
  85. WP_Query secondary query failing
  86. Custom search (wp query by custom fields)
  87. pre_get_posts or $where, which one to use?
  88. Sorting is not working in WordPress WP_Query
  89. Add custom WP_Query after the first 3 posts
  90. Limit the number of posts from a specific category on index.php
  91. Some images not being returned with wp_get_attachment_image
  92. Weird results using wp-query with ‘date_query’ for last week
  93. Query for page content, and query for posts on the same page?
  94. Limit the number of posts via wpquery
  95. WP query with multiple custom meta not respecting orderby
  96. 1500+ duplicate queries via get_option function (query monitor)
  97. WordPress Ajax search filter on dropdown select
  98. Adding a language rule and displaying posts with a custom taxonomy term on its archive page
  99. Use custom url params with value from a custom field to return the post containing the field value
  100. WP_Query on custom taxonomy -> Location and Activity