Finding rows in a table with a foreign key pointing back at itself where the referenced row differs in a certain column
SELECT t1.*
FROM Organisation t1
JOIN Organisation t2 ON t1.id = t2.parent_id
                    AND t1.platform_id != t2.platform_id;