直接看Sql即可：
delete tableA a from tableA a left join tableB b on a.netbar_id = b.netbar_id where b.role_id = 0;
Mysql多表关联删除操作
原文：http://www.cnblogs.com/longzhongren/p/4654432.html
