declare @companyid int;
	set @companyid = 27;

	WITH companies(Id, Name, CompanyId) AS 
	(
		select childCompany.Id, childCompany.Name, childCompany.CompanyId
		from dbo.Company childCompany
		where childCompany.Id = @companyid
		union all
		select parentCompany.Id, parentCompany.Name, parentCompany.CompanyId
		from dbo.Company parentCompany
			inner join companies d
		on d.CompanyId = parentCompany.Id
	)
	SELECT companies.Id as CompanyId, perm.PermissionId as PermissionId
	FROM companies 
		inner join dbo.Permission perm
	on perm.CompanyId = companies.Id