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