WordPress the_author_posts_link

I have a loop where I post list of authors with SQL Query. I also need to post the_author_posts_link with links to author pages. When I put it into loop it renders only the 4th entry for every iteration:

foreach ($all_users_id as $i_users_id ) :


$user = get_userdata( $i_users_id );

the_author_posts_link();

$email = $user->user_email;
echo $email;
?>

<?php endforeach; ?>