Creare la query giusta

[Emulman]

se non erro

SELECT T1.categories_id, T1.parent_id FROM Tabella1 AS T1 INNER JOIN Tabella2 AS T2 ON T1.parent_id = T2.categories_name, INNER JOIN ON T1.categories_id = T2.categories.name;