Display of previous and next posts associated with the author

I am reprinting a question I recently asked on GenerateBlockcommunity.

I would like to display the previous and next posts associated with an author.
I was given the following code, but had the following two problems

add_filter( "get_next_post_where", function($where, $in_same_term, $excluded_terms, $taxonomy, $post){
  $where .= " AND p.post_author='".$post->post_author."'";
  return $where;
}, 10, 5);

add_filter( "get_previous_post_where", function($where, $in_same_term, $excluded_terms, $taxonomy, $post){
  $where .= " AND p.post_author='".$post->post_author."'";
  return $where;
}, 10, 5);

First, the title of the next post is displayed correctly, but the link for does not work.
Second, the dates of the previous and next posts show the latest date.

Please let me know the solution.