SELECT *
FROM `oio_category` `c`
LEFT JOIN `tbl_related_cat` `r` ON `c`.`category_id`=`r`.`related_cat_id`
WHERE `r`.`catid` = 'copper-lightning-arresters'