Small Swoole Db 2.3에서는 왼쪽 조인을 소개합니다.:

$selector = (new TableSelector('user'))
    ->leftJoin('post', 'messageOwner', 'message')
;

$selector->where()
    ->firstCondition(new Condition(
        new ConditionElement(ConditionElementType::var, 'name', 'user'),
        ConditionOperator::equal,
        new ConditionElement(ConditionElementType::const, 'john')
    ))->andCondition(new Condition(
        new ConditionElement(ConditionElementType::var, 'subject', 'message'),
        ConditionOperator::like,
        new ConditionElement(ConditionElementType::const, '%hiring%')
    ))
;

packagist : https://packagist.org/packages/small/swoole-db
자식 : https://git.small-project.dev/lib/small-swoole-db