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. WP_Query orderby date not working
  39. How to exclude products by tag from woocommerce shop page?
  40. Filtering posts by custom field value not working
  41. wpdb get results doesn’t work with variable
  42. Multiple meta queries but arrange by specific meta value order
  43. Custom pagination with WP_Query generating 404 error
  44. Query post with meta_query where date is not in future
  45. Apply CSS class to every second database record [closed]
  46. pre_get_posts order by not working
  47. How do I change the order (ASC and DESC) in the following retrieval method using WP_Query?
  48. How to get all child pages in their parent page?
  49. how do we display all posts from a particular category in homepage?
  50. Display both standard posts in a specific category along with a custom post type in a single loop?
  51. Orderby is working with one query but not with other
  52. meta_query in WP_Query value is not accepting array
  53. How to order posts by title after they have already been sorted by category
  54. How to query custom post types with mixed AND & OR statements for custom fields
  55. Custom post type archive pagination query issue
  56. WP Group posts by year(desc) > month(desc) > date(asc)
  57. Check the Specific Meta Key IF its Meta Value is Empty then… (WP Post Meta Query)
  58. How I can change the condition or compare operator for WP_Query in pre_get_posts
  59. Filtering posts by archive showing all years
  60. Apply filters to main query instead of creating new one?
  61. Why having more than 10 clauses in WP_Query results in some outputs being dropped?
  62. mysql query order by
  63. Content not displaying on paginated page
  64. show custom category posts from a custom post type
  65. how to load posts to a custom post template after using template_redirect or template_include
  66. 2 queries with counters
  67. Multiple Query_Posts
  68. Page template doesn’t display simple HTML if inserted into other page?
  69. Query multiple post types, but different order for each
  70. How to add date_query to meta_query array
  71. Order by the first array within a meta_query
  72. Multiple nested meta queries
  73. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  74. Custom query for custom post type not getting correct post ID
  75. How to merge these two post queries?
  76. How to search posts by title with special characters in WP_Query?
  77. How can I query a radius of coordinates?
  78. WP_Query: Query posts only if their access is restricted to logged user’s role
  79. Get specific value from variable to use in query
  80. WP_Query with meta_query won’t orderby
  81. Adding Category in WP_Query Not Working
  82. display all posts from category with and without terms in chronological order
  83. How to create page that lists tags by initial letter?
  84. Seach and categories not working when ignoring sticky posts in main loop
  85. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  86. WordPress: Cron locking and Queue
  87. Correct Way To Run Multiple Queries Sharing Some Base Data
  88. how to query for meta_value have array
  89. How to make the default WordPress search return borader results
  90. WP_Query shows all posts on single post pages
  91. Show sticky post before other WP_Query
  92. List ALL posts within last week from current category on category page
  93. WP_Query on “property” in the options table
  94. Dynamically name array in WordPress loop – add/get values
  95. Creating Custom Query
  96. Hook to get the query result after listing posts
  97. Elementor custom query
  98. WordPress extremely slow when using get_posts with multiple meta_query relations
  99. Refresh wp_query with no changes
  100. Search results stuck on page 1