SELECT 
  CONCAT(u.firstname, ' ', u.lastname) 
FROM 
  cscart_blog_authors as b 
  LEFT JOIN cscart_users as u ON b.user_id = u.user_id 
WHERE 
  b.page_id = 103

Query time 0.00027

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE b ref PRIMARY PRIMARY 3 const 2 Using index
1 SIMPLE u eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.b.user_id 1

Result

CONCAT(u.firstname, ' ', u.lastname)
Krzysztof Ksepko
Marc Böheim
Adrian Daniluk