insert select

INSERT INTO permissions_groups (group_id, permission_id)
    VALUES (2, (
        SELECT permissions.id
        FROM permissions
        WHERE permissions.name = 'admin_support'
    )