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