This
$sql = "DELETE FROM groups_members WHERE groups_id =" . $groupId . " AND user_id =" . $userId . "";
instead of
$sql = "DELETE * FROM groups_members WHERE groups_id =" . $groupId . " AND user_id =" . $userId . "";
should solve the syntax error.
Important: Use parameterized queries to avoid SQL injection.