SELECT 
  CONCAT(u.firstname, ' ', u.lastname) as author, 
  b.page_id 
FROM 
  cscart_blog_authors as b 
  LEFT JOIN cscart_users as u ON b.user_id = u.user_id 
WHERE 
  b.page_id IN (
    132, 129, 127, 126, 125, 124, 122, 120, 
    102, 58
  )

Query time 0.00042

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE b range PRIMARY PRIMARY 3 15 Using where; Using index
1 SIMPLE u eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.b.user_id 1

Result

author page_id
Krzysztof Ksepko 58
Marc Böheim 58
Adrian Daniluk 58
Krzysztof Ksepko 102
Marc Böheim 102
Adrian Daniluk 102
Anna Pawlak 102
Krzysztof Ksepko 120
Marc Böheim 120
Anna Pawlak 120
Krzysztof Ksepko 122
Marc Böheim 122
Krzysztof Ksepko 124
Marc Böheim 124
Krzysztof Ksepko 125
Marc Böheim 125
Anna Pawlak 125
Krzysztof Ksepko 126
Krzysztof Ksepko 127
Marc Böheim 127
Anna Pawlak 127
Anna Pawlak 129
Krzysztof Ksepko 132
Marc Böheim 132
Anna Pawlak 132