source    target
 1        2
 2        3
 2        4
 3       -1
 4       -1

delete from test.orphan_table where source = 2 or target = 2;

source    target
 3       -1
 4       -1