Subquery in WHERE statement

#1

Hello, how I can make request like this:

SELECT * FROM disk WHERE host = (SELECT “host” FROM docker_container_cpu WHERE “engine_host” =~ /^$host$/)