This depends on where you are calling the query and what other information might be available inside of that loop or template tag.
If you’re calling that function for each author every time something happens then for each unique author it is hitting the DB with another query, and in my opinion that’s always something to worry about.
