Как-то так:
$dannie = $modx->query("SELECT D.name,D.fam,D.nomer,L.skidka FROM dannie D JOIN `login` L ON L.id = D.nomer WHERE nomer IN(SELECT id FROM login WHERE prava = '2')")->fetchAll();