实体类关联

        province1_.name as col_0_0_ 
    from
        dodo_city city0_ 
    inner join
        dodo_province province1_ 
            on city0_.province_id=province1_.id 
    where
        city0_.id=? limit ?
Record [rawData={provinceName=福建}]

测试数据：admin表

结果：

    select
        role0_.name as col_1_0_ 
    from
    left outer join
        dodo_admin admin1_ 
            on role0_.admin_id=admin1_.id
Records [rawData=[
    {adminName=超级管理员, roleName=总监}, 
    {adminName=码叔, roleName=经理}, 
    {adminName=null, roleName=超级角色}]]

测试数据：role表

    select
        admin1_.name as col_0_0_,
        role0_.name as col_1_0_ 
    from
        dodo_role role0_ 
            on role0_.admin_id=admin1_.id
Records [rawData=[
    {adminName=超级管理员, roleName=总监}, 
    {adminName=码叔, roleName=经理}, 
    {adminName=报表管理员, roleName=null}]]

结果：

    select
        province1_.name as col_0_0_ 
    from
        dodo_city city0_ cross 
    join
        dodo_province province1_ 
    where
        city0_.name=province1_.name limit ?