Setting Navigation Drop down to coincide with Author Template

My website is: https://www.fulltankstudio.com

Where the menu is on top, theres a “blogger” menu that i created. When you hover over it, it automatically picks up all the authors. Now what I want it to do is link it to the Authors to their Author page.

Example: When you pick the blogger “rens.eno” – I want it to direct to this page:

https://fulltankstudio.com/blog/author/rens-eno/

What’s the code to do this? This is what I put down….

• <?php if($pages_title===”” || !$pages_title) { echo ‘bloggers’; } else { echo $pages_title; } ?>

<?php
$order = ‘user_nicename’;
$user_ids = $wpdb->get_col(“SELECT ID FROM $wpdb->users ORDER BY $order”); // query users
foreach($user_ids as $user_id) : // start authors’ profile “loop”
$user = get_userdata($user_id);
?>
• <?php the_author_posts_link(); ?>

<?php
endforeach; // end of authors’ profile ‘loop’
?>

Can anyone help me with this??