Many2Many Preload Conditions

[fari-99]

I have a table Users & Companies, user can join many company, and company can have many user. because of that, i decided to create a many2many table called UserCompanies. this user companies have user_id, companies_id, created_at, deleted_at, and status. because we want to know, when the user get deleted from the companies and if the user are still active or not.

how can i preload conditions if i want all companies that user still active? currently i use this, but i got error Unknown column 'status' in 'where clause'.

       db := DB.Debug().Preload("Companies", func(DB *gorm.DB) *gorm.DB {
			return DB.Where("status = ?", "active")
		}).Find(&userModel)

thank you for your help in advance.
note: there is already questions issue on #6479 , but the answer are not satisfying at all.

[fari-99]

after many thinkering, i decided to do this instead

        var userModel models.Users
	err := cc.DB.Debug().
		Preload("Companies", func(DB *gorm.DB) *gorm.DB {
			return DB.Select("DISTINCT(companies.id), companies.*"). // data not distinct
				Joins("LEFT JOIN user_companies ON companies.id = user_companies.companies_id"). // join with many2many table
				Where("status = ?", "active")
		}).Find(&userModel).Error