对别名使用join multiple time，如下所示：

SELECT 
    parking.date,
    parking.time,
    parking.pname,
    parking_violations.code,
    parking_violations.section,
    parking_violations.description
FROM 
    parking
INNER JOIN parking_violations ON parking.v1=parking_violations.ID
inner join parking_violations a ON parking.v2=a.ID
inner join parking_violations b ON parking.v3=b.ID
inner join parking_violations c ON parking.v4=d.ID
WHERE 
    pdid=5

像@fa06 explain一样，您可以对同一个表使用多个联接，但是我将使用left join来代替内部联接，这样我就可以灵活地获取行，而不是所有vn都在表上有匹配的id。

SELECT 
    parking.date,
    parking.time,
    parking.pname,
    pv1.code,
    pv1.section,
    pv1.description,
    pv2.code,
    pv2.section,
    pv2.description,
    pv3.code,
    pv3.section,
    pv3.description,
    pv4.code,
    pv4.section,
    pv4.description
FROM
    parking
LEFT JOIN
    parking_violations AS pv1 ON pv1.ID = parking.v1
LEFT JOIN
    parking_violations AS pv2 ON pv2.ID = parking.v2
LEFT JOIN
    parking_violations AS pv3 ON pv3.ID = parking.v3
LEFT JOIN
    parking_violations AS pv4 ON pv4.ID = parking.v4
WHERE 
    parking.pdid = 5;