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