//ユーザーから責任者取得
List<user> userList = [SELECT ID, ContactId, Contact.Firstname, Contact.Lastname, ProfileId, Profile.Name FROM User];
List<Id> conIdList = new List<Id> ();
for(user item : userList){
conIdList.add(item.AccountId);
}
// 責任者から取引先検索
List<Contact> conList = [select id,AccountId from Contact where id in :conIdList];
List<Id> accIdList = new List<Id> ();
for(Contact item : conList){
accIdList.add(item.AccountId);
}
//取引先より立会検索
List<Lihui__c> Lihui_List = [select id, Acc__c from Lihui__c where Acc__c in :accIdList];