select u 
from User u
join WorkGroup wg on u in (wg.assignedUsers)
where u.status='AVAILABLE'

org.hibernate.NotYetImplementedFor6Exception: org.hibernate.query.sqm.sql.internal.PluralValuedSimplePathInterpretation
	at org.hibernate.query.sqm.sql.internal.PluralValuedSimplePathInterpretation.accept(PluralValuedSimplePathInterpretation.java:73) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.visitInListPredicate(AbstractSqlAstTranslator.java:5247) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.ast.tree.predicate.InListPredicate.accept(InListPredicate.java:66) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.renderTableGroup(AbstractSqlAstTranslator.java:3829) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.renderTableGroupJoin(AbstractSqlAstTranslator.java:4144) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.processTableGroupJoin(AbstractSqlAstTranslator.java:4109) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.lambda$processTableGroupJoins$5(AbstractSqlAstTranslator.java:4089) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) ~[na:na]