使用LINQ中另一个子查询的值填充字段

我有以下Linq，我可以使用Linq这样获得值IsPremiumUser和IsLawFirm在去还是有任何其他的好方法来做到这一点?

我需要的是获得IsPremiumUser和IsLawFirm的值基于他们的供应商id。我不想添加任何foreach来做这项工作，我可以使用LINQ来获得这些值

var supplierListQuery = 
    (from sup in db.PPSuppliers
     select new SearchResultSupplierViewModel
     {
         SupplierId = sup.PPSupplierId,
         SupplierLocation = sup.LocationsForDisplay,
         CreatedDate = (DateTime)sup.CreatedDate,
         PPMemberId = sup.PPMemberId,
         IsPremiumUser =
             (from u in db.PPSubscriptions
              join s in db.PPSubscriptionPlans on u.SubscriptionPlanId equals s.SubscriptionPlanId
              where u.PPMemberId == sup.PPMemberId && u.SubscriptionEndDate >= System.DateTime.Now
              orderby u.SubscriptionStartDate descending
              select s).FirstOrDefault().isPremium,
         IsLawFirm = 
             (from l in db.PPSupplierSupplierTypes 
              join f in db.PPSupplierTypes on l.PPSupplierTypeId equals f.PPSupplierTypeId
              where l.PPSupplierId == sup.PPSupplierId && f.PPSupplierTypeId == 1
              select l).Any()
     });