SELECT shop.*, category.* FROM shop left outer join category on shop_category_id = category_id where shop_status = '1' and shop_id = 34 limit 1