SELECT *
 FROM table1
 WHERE table1.category = 1
 UNION
 SELECT *
 FROM table1 JOIN table2 ON table1.category = table2.parent_id
 WHERE table2.parent_id = 1