Consult about the problem of belongsTo association in thinkphp5

situation description:
A Table: user"s coupon Information Table, Field: id,ticket_id,status
B Table: voucher Information Table, Field: id,ticket_info,status
in Model A, there is the following code:
class An extend Model
{
public function getUserTicket ($user_id)

{
    $userTicketInfo = $this->field([
        "status",
        "ticket_id"
        ])
        ->where([
            "user_id"=>$user_id,
            "status"=>0
        ])
        ->with([
            "B" => function($query) {
                $query->field([
                    "id",
                    "ticket_info"
                ]);
            }
        ])
        ->select();
 return $userTicketInfo;

}
public function belongB ()

{
    return $this->belongsTo("B","ticket_id","id")->setEagerlyType(0);
}

}

now if you search in this way, you can get the correct result, but if you change setEagerlyType (0) to setEagerlyType (1), it will prompt the question that id and status are not unique. The question to think about is:
1. Is this way of use correct?
2, setEagerlyType (0) use IN mode, changed to setEagerlyType (1) the original meaning is to switch to join mode, but id, status is not the only problem, how to write here?

Feb.28,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bf5a5b-31fae.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bf5a5b-31fae.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?