Delete with Join in MySQL
DELETE `t` FROM `category_translation` AS `t` LEFT JOIN `category` AS `c` ON `c`.`id` = `t`.`id` WHERE `c`.`id` IS NULL;